After thinking about some, I think I can ask my question in a clean manner.
How do I convert a Varchar data field into a list? Can someone tell me what I'm doing wrong? I have a query see below where the value (a varchar) of category.category_common is -> 2,3 I add the ( ) in the query below to convert category.category_common into a list item. The query below will only locate the first item in category.category_common which is 2 ************************************************************************************************************************************* Select content_title, content_category, content_order, content_name1 from content, category where category.category_id = 'Intbk' AND content.content_common IN (category.category_common) Order by content.content_order ************************************************************************************************************************************* The query below works, when I manually add the list lite (2,3). ############################################################################ Select content_title, content_category, content_order, content_name1 from content, category where category.category_id = 'Intbk' AND content.content_common IN (2,3) Order by content.content_order ############################################################################ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
