Re: Large Like Queries

[Brent Baisley]

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%' 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....

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php