Posted by John Drako on 02/20/07 16:55

This is for MySQL 5.0

I took over some php/mysql code and I'm trying to optimize it if
possible.

I have one select statement on an indexed varchar field that gets built
and used quite frequently. The field contains a series of keywords or
tags. The query is supposed to find the user's selected tags and
sometime find the rows that exclude certain tags.

The existing query is like so:

SELECT * FROM tableName WHERE tagsField LIKE '%tag1%' AND tagsField LIKE
'%tag2%' AND tagsField NOT LIKE '%tag3%' AND NOT LIKE '%tag4%';

the tags selected or excluded could reach as many as 30 making the query
long.

Is there a better way of doing this type of query?

TIA

John

[Back to original message]