MySQL Forums
Forum List  »  Quality Assurance

hi guys, i want to know function base-index
Posted by: james zhang
Date: February 23, 2011 08:09PM

hi:
I have a table, like
CREATE TABLE test (
id INT,
name CHAR(30),
status INT
);

INDEX ON name.

but I use this query,
SELECT * FROM test WHERE char_length(name) > 5;

explain this query is right use where, but I remember mysql not support function base-index, why explain query is right use where?

Options: ReplyQuote


Subject
Views
Written By
Posted
hi guys, i want to know function base-index
2020
February 23, 2011 08:09PM


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.