deezy Posted May 29, 2008 Share Posted May 29, 2008 Hi. There are values in my database stored like so: +----------+ | num | +----------+ |2,4,8,9,11 | A dropdown on my webpage contains a list of numbers. Is it possible to query the database to return all rows that contain one of the numbers in the 'num' field even though they are separated by commas? Thanks Quote Link to comment Share on other sites More sharing options...
deezy Posted May 29, 2008 Author Share Posted May 29, 2008 Just bumping this as i have still not been able to find a solution, thanks Quote Link to comment Share on other sites More sharing options...
fenway Posted May 30, 2008 Share Posted May 30, 2008 Yes... use FIND_IN_SET(). Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.