Search through tags

[Ge64]

MySQL: 4.1.22

 

I have a table with a number of cols, one of which is named 'tags' and the tags are in a format such as 'cat mouse plant food stuff'. I now use the following query to get rows with matching tags:

 

SELECT id,data FROM information WHERE tags LIKE '% tag %'

 

However, this only finds tags that are in the middle, not the first and last ones unless I add spaces before and after them. If I remove the spaces from the query, it will also find tags that have nothing to do with it (eg I search for 'cat', it will return anything with 'caterpillar' in it as well). What is a better way to do this?

[mezise]

Use this:

SELECT
  id, data
FROM information
WHERE
  tags REGEXP "[[:<:]]tag[[:>:]]"
;