mysql query where clause with comma separated values?

[php_begins]

Hi, Can I have a comma separated values in WHERE clause of an MYSQL select statement?

Something like this,

$id=100,102;

 

SELECT id,name from tablename WHERE id='$id';

 

I need to display all ids where the names where id=$id. The $id variable is a dynamic comma separated ids.

[Maq]

Comma separated values should be avoided, it's poor design and causes a lot of headache.  If you have to check these then you can use IN()

http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_in

[php_begins]

Thanks,why do u think its not effiecient?

[fenway]

Thanks,why do u think its not effiecient?

It *is* inefficient -- it's lazy storage in 99% of the use cases.