Results 1 to 6 of 6
Sep 20, 2012, 22:55 #1
- Join Date
- Jun 2005
- Sydney, Australia
- 0 Post(s)
- 0 Thread(s)
MySQL: Find if a value is in a list of values
I have a text field that contains a list of IDs e.g. 16,20,24,29,38,40
I need to find any records where that field contains a particular ID.
I thought that something like SELECT * FROM tablename WHERE IDlistfield CONTAINS myID but that doesn't work.
Can anyone point me in the right direction?