I have a list of certain data (basically a number) that is separated by commas.
If I wanted to make conditions in my query to the database, what is the best way?
WHERE attribute_values = #form.searchsize#
The #form.searchsize# (if your curious to what kind of variable, it is coldfusion) is a variable passed on through a form. I basically need the field attribute_values to be searched in a each record. Each attribute_values contains several size numbers. IE - 1,2,3,4,5,.... How would I be able to question the database if #form.searchsize# is one of these numbers in the list?