Find the capital and the name where the capital includes the name of the country

Answer:

 

SELECT name,capital ¬†ROM world¬†WHERE capital LIKE concat(concat(‘%’,name),’%’)

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by k2schools