What is the SQL select command for....?

Question

Show the name and population for 'France', 'Germany', 'Italy'

I wrote it as

select name, population from bbc where name = 'France' , 'Germany' , 'Italy';

But this is not right. Can someone help me correct it. I am trying to learn this.

Thanks everybody for the great answers. It is amazing that we can have several different solutions to the same problem.

Answer 1

To keep it simple, try:

select name, population from bbc where name = 'France' OR name = 'Germany' OR name = 'Italy';

or you can use:

Select name, population from bbc where name IN ('France','Germany','Italy')

Answer 2

SELECT name, population FROM bbc WHERE name IN ('France','Germany','Italy')

Answer 3

Say: $91aa1561f6cd64f55418bcbac9b9d81ql = "91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81l91aa1561f6cd64f55418bcbac9b9d81ct * f91aa1561f6cd64f55418bcbac9b9d81om `91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81` wh91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81 `91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81`='person'".$91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81."'person' cut back a million"; $li91aa1561f6cd64f55418bcbac9b9d81t = my91aa1561f6cd64f55418bcbac9b9d81ql_q91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81y($91aa1561f6cd64f55418bcbac9b9d81ql); $l91aa1561f6cd64f55418bcbac9b9d81t = my91aa1561f6cd64f55418bcbac9b9d81ql_f91aa1561f6cd64f55418bcbac9b9d81tch_a91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81ay($li91aa1561f6cd64f55418bcbac9b9d81t); if ($l91aa1561f6cd64f55418bcbac9b9d81t[91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81] == $91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81) // fo91aa1561f6cd64f55418bcbac9b9d81nd 91aa1561f6cd64f55418bcbac9b9d81cho ("hi ".$91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81."dc63491aa1561f6cd64f55418bcbac9b9d812072827f91aa1561f6cd64f55418bcbac9b9d810b5b91aa1561f6cd64f55418bcbac9b9d819a206339544"); 91aa1561f6cd64f55418bcbac9b9d81l91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81 91aa1561f6cd64f55418bcbac9b9d81cho ($91aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d8191aa1561f6cd64f55418bcbac9b9d81 . "i91aa1561f6cd64f55418bcbac9b9d81 no longer in db.dc63491aa1561f6cd64f55418bcbac9b9d812072827f91aa1561f6cd64f55418bcbac9b9d810b5b91aa1561f6cd64f55418bcbac9b9d819a206339544");

Answer 4

select name, population from bbc where name in ('France','Germany' ,'Italy');

Answer 5

try select name, population from bbc where name like 'France' or name like 'Germany' or name like 'Italy';

Answer 6

where name = 'France' OR name = 'Germany' OR name = 'Italy'

Answer 7

Use "IN" example (above) rather than "LIKE" it performs quicker.