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
Anyhow, you get the idea. Say I have those two rows in my DB (the rows' contents are irrelevant)
- id: 2
- photo: blowfish.jpg
- tags: Aqua, Fish, Funny, Ocean Cool
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! Any help is appreciated.
"Give me the place to stand, and I shall move the earth" - Archimedes
"The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts." - Bertrand Russell