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%
gt;
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Chris Stark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 16, 2002 10:25 PM
Subject: Large Like Queries
> Hi,
>
&
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, my