I am tasked with writing a few MySQL queries and I stuck. I must write a query to show the athlete’s name and the name of their country but only for names that contain the string 'wang' anywhere in the name.
My previous statements queried fine but I am confused on how to achieve the above output. I am using two different tables and joining them. Previous statements was:
Right JOIN country ON ttms.country = country.id
WHERE color = 'gold';
Take a look at this link,
Use the LIKE keyword to make your query,
SELECT * FROM Customers WHERE Country LIKE '%land%';