I don't believe indexes are used in queries that use "LIKE"
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
> SuperStats.com
> Free Visitor Statistics for your Website
> http://www.superstats.com
>
> -----------------------------------------------------------
> Send a mail to [EMAIL PROTECTED] with
> unsubscribe mysql [EMAIL PROTECTED]
> in the body of the message to unsubscribe from this list.
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
