Merging text in like queries

You can concatenate text to generate a dynamic condition for the like.

Show the name and capital of countries who's capital contain the country name. For example, "Mexico city" contains "Mexico"

SELECT name, capital FROM world WHERE capital like '%' || name || '%'

NEXT EXERCISE