|
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
Navigation:
[Reply to this message]
|