More than one term in category field???
Posted: Tue Mar 31, 2009 3:49 pm
I am setting up a SQL query that will be used to filter search results with a WHERE clause. In my MySQL DB, I have set up a "cat" column. Is there a way to enter more than one term in the cat field so I can give each row more than one category (such as 'child,solid')? I tried using an "," and ";" delimiter, but neither worked. It seems to only work if I have only one category in the cat field.
Thanks in advance for any help!
Gary
Thanks in advance for any help!
Gary