At 9:31 AM -0700 4/26/01, Shane Gentry wrote:
> Does it help to put an Index on a column when you
> use a LIKE query.
>
> ex. SELECT * FROM users WHERE name LIKE '%tom%'
>
> Thanks in Advance!
>
In this case, It won't help, since you have a wildcard at the
beginning of your pattern. If you u
Does it help to put an Index on a column when you
use a LIKE query.
ex. SELECT * FROM users WHERE name LIKE '%tom%'
Thanks in Advance!
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
