Hi, I was just wondering if anyone has any tricks for speeding up huge queries that require a LIKE comparison, and also a wild card at the front and back of the search term. For example:
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.... Thanks, Chris --------------------------------------------------------------------- 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