MR12PLAY MR12PLAY - 1 year ago 88
SQL Question

Student/Newbie in need of help learning the basics

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:

Select *
FROM ttms
Right JOIN country ON =
WHERE color = 'gold';

How do write the correct statement?

Answer Source

Take a look at this link,
Use the LIKE keyword to make your query, %wang% From

SELECT * FROM Customers
WHERE Country LIKE '%land%';
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download