MySQL Forums
Forum List  »  Newbie

Re: search comma separated db column
Posted by: Jon Hollis
Date: April 24, 2008 03:44PM

I spent about an hour Googling this earlier and found no answers. First thing I type in after the above post gave me an answer. The exact query:

SELECT * FROM `jos_content` WHERE FIND_IN_SET('57', cat_tag) > 0

Pulls out everything tagged with the integer 57. cat_tag being the column containing comma separated integers.

Options: ReplyQuote


Subject
Written By
Posted
Re: search comma separated db column
April 24, 2008 03:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.