[RESOLVED] Isolate mysql data

[coldwerturkey]

I have a column entry_tags set at varchar(100) NOT NULL. The idea of it being tags that will have multiple descriptions/tags posted in (either by text separated with a space or coma).

I want it to isolate each word and project it as itself with a link of itself preferably separated by a coma. How would I accomplish this (if the tables even correct)?

Just incase I was vague;

user input: tag1, tag2, tag3,

output: <a href="?search=tag1">tag1</a>, <a href="?search=tag2">tag2</a>, etc..

Thank you in advanced

[nemonoman]

Placing multiple data elements in a single field is a Bad Idea.

You want to create a related table -- simple really:
messageID
tag

and populate that table with individual tag items
messageID: 1
tag: database

messageID: 1
tag: related tables

messageID: 2
tag: related tables

messageID: 3
tag: related tables

messageID: 3
tag: database

etc

Then you'll use a JOIN to find the messages related to the tags

SELECT * FROM message
INNER JOIN messageTag ON messageID=message.ID
WHERE tag='database'
GROUP BY messageID

OR multiple tags:

SELECT * FROM message
INNER JOIN messageTag ON messageID=message.ID
WHERE tag IN ('database','related tables')
GROUP BY messageID

etc