select question

[interactive]

ok i have my mysql_query("SELECT * FROM tablename WHERE number='1-4'");
how would i do that so it selects rows that would contain either 1,2,3, or 4? all help is appreciated..

[Anon]

SELECT * FROM tablename WHERE number='1' or number='2' or number='3' or number='4'

This would return a match if the number field contained single digits. You may want to use LIKE '%1%' or LIKE '%2%' etc. if you want a match where the number field contains the number along with other characters.

or of course you can use the pipe symbol instead of "or".