SQL Coldfusion question
Posted on 2004-10-17
Well, I met another problem I cant see a solution to.
In my database a column contains a list of IDs as a string which is generated by checkboxes. I need a right solution to query the database.
Say, one record can contain just number 1 and another 1,3,4,9.
In my search form I also use checkboxes and got a list.
Say a search string is 1,4,9
I need a query which will look at the list from search form, compares value with the recorded string and if it matches the record is queried.
Say in my case I must get both records, because first one contains "1" and second one contains "1", "4" and "9".