Brett Error wrote:
> I have a query:
> select page from pages where page_url like
> "http://members.aol.com/blahblah/index.htm%" limit 1
>
> Would an index on page_url speed this query along?
>
> Thanks,
>
> ______________________
> Brett Error
Yes, an index would make that query faster, just as long as there is a
constant string before the '%'...
Faster: LIKE 'blah%'
Faster: LIKE 'bla%h'
Not faster: LIKE '%blah'
--
Daniel Koch
American City Business Journals
http://www.amcity.com/
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
