MySQL Forums
Forum List  »  Optimizer & Parser

Problem using LIKE with FORCE INDEX...
Posted by: Jonathan Segura Castro
Date: February 04, 2008 11:02AM

Hi.. I have a question, because when I try to use the LIKE sentence with the FORCE INDEX sentence, the LIKE sentence ignore it.?? I have the next SQL

EXPLAIN SELECT filename FROM users u force index (uniqUsername) where username like "%ill%" ;

The result is:

possible_keys = NULL
key = NULL

Where that table has a index named "uniqUsername" ??..
Why the LIKE sentence not repect it?

Thank's

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem using LIKE with FORCE INDEX...
8153
February 04, 2008 11:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.