Have you thought about creating a fulltext index? Then you can search on
any word in a field. MySQL 4 has a lot more options for fulltext search,
but you can still do it in 3.
On Monday, December 16, 2002, at 04:25 PM, Chris Stark wrote:
SELECT my_id FROM my_table WHERE my_value LIKE '%ABCDEFG%
Chris,
> SELECT my_id FROM my_table WHERE my_value LIKE '%ABCDEFG%' LIMIT 50;
> I know that in a query such as this, mysql does not utilize indexing, so I
> was just curious how some others have attempted to speed up this kind of
> thing up
Maybe this answer won't help too much, but I experie
