hi. i have 2 tables:
tags (id_tag,name)
news (id,title,data,tags)
The field newstags is a varchar(255). Im planning to put data like this in that field: "1,7,34"
That means that a particular row in news is linked to tags 1, 7 and 34 from the tags table.
Then, how can i search for ALL news records that have the 34 value (among others) in the tags field?
Is there a better way to do this?