Tag based searching in MySQL

So, I’m working on a web-app that uses tag-based searching of items in a database (well, it does more than that, but for the purpose of this post, that’s what it does).

Say I’ve got a table row with the following column and row values:
]photo: neato_picture.jpg
[]tags: Cool, Awesome, Friends, Funny[/LIST][LIST=1]
]id: 2
[]photo: blowfish.jpg
]tags: Aqua, Fish, Funny, Ocean Cool[/LIST]Anyhow, you get the idea. Say I have those two rows in my DB (the rows’ contents are irrelevant)

What does the query look like to look through the tags column and return all rows that have the tag ‘Cool’ associated with them.

Thanks in advance guys! :slight_smile: Any help is appreciated.