hi guys, i want to know function base-index
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?
Subject
Views
Written By
Posted
hi guys, i want to know function base-index
2020
February 23, 2011 08:09PM
972
February 23, 2011 08:11PM
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.