This is my question:
Find the capital and the name where the capital includes the name of the country.
This is my answer:
SELECT name,capital FROM world WHERE capital=concat(name,"NULL")
I dont understand what should i do in the "WHERE" part.
Should i do capital=concat(name,something?) or IN or LIKE?
Can you help me please? Thank you.
The question is from this link: http://sqlzoo.net/wiki/SELECT_names Question 13