Hello,
I am sending a comma seperated id string to my php like this : 214,235,224 and in mysql table I have ids from 1 to 1000. I want to get the rows with ids 214,245 and 224 . ( not with where id =214 or id=235 etc..) because the ids wil be random every time. How can I use there where query for this. mysql need to find those rows with the ids like:
select * from table where id "is one of the ids in the string sepereated by comma" (214,235,224)
Thanks
I am sending a comma seperated id string to my php like this : 214,235,224 and in mysql table I have ids from 1 to 1000. I want to get the rows with ids 214,245 and 224 . ( not with where id =214 or id=235 etc..) because the ids wil be random every time. How can I use there where query for this. mysql need to find those rows with the ids like:
select * from table where id "is one of the ids in the string sepereated by comma" (214,235,224)
Thanks