Re: querying comma seperated values in a db field?

[Stephen Madison]

Here is my sql statement:

$sql_statement ="

SELECT product.product_id, product.product_name, product.product_imgsm, product.product_xcat, category.category_header_name, category.category_imgsm FROM product JOIN category ON product.product_xcat=category.category_id WHERE product_xcat IN($dbins_fd_ref) ORDER BY RAND($product_name) limit 3

";


All that I need to do is make the WHERE clause search for a string literal that is respresented by the $dbins_fd_ref variable in a comma separated list that resides in the product_xcat column of the product table and return the select statement results when the string literal is found. I do not need for ALL of the comma seperated values to match, I am looking for the existance of the $dbins_fd_ref literal in one or more of the comma separated values of the product_xcat column.

I have tried IN and FIND_IN_SET with no luck.

Thank you for helping me with this.