Getting to actually test this hasn't been as easy as I'd hoped. If I can get
something definitive I'll post.
On Wed, Sep 8, 2010 at 3:45 PM, W
>
> mike,
>
> Please let us know what you find out. I'm very curious of this myself. As
> the document clearly states, mysql will use an index when you use a like
> but
> don't start the string with a wildcard. So we know that
> Left(str,5) = 'string' VS WHERE str LIKE 'string%'both will use an index.
> The question now becomes the cost of using LEFT vs using the LIKE.
>
> BTW, I assume you meant where left(str, 6) = 'string'.
>
>
>
