Syntax for Select Statement

[newphpcoder]

Good day!

I want to know if what is the correct sysntax for Selecting multiple data in one column.

I have a table trace and i have column name and id
my list name are: name1, name1total, name2,name2total,name3,name4, and name5, but i wamnt to select only is the name 1,name3,name4, and name5
I have a table trans and it has id.

I try this code:

SELECT t.name FROM trace t, trans c WHERE t.name = 'name1' || 'name 3' || 'name4' || 'name5' AND t.id=c.id;

In that code all the name was selected eventhough I did not select the name1total,name2,name2total.

Thank you

[bradgrafelman]

That's because your syntax in the WHERE clause is incorrect - each statement between the vertical bars is evaluated separately, so you're first evaluating "t.name = 'name1'", and then "'name 3'" which is considered true, thus matching everything.

Either compare each string to the 'name' column, or use the IN() expression.