How do you index just the first four bytes of the column?
Answers were Sorted based on User's Feedback
Answer / amith
ALTER TABLE customers ADD INDEX (business_name(4))
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / monika
alter table table_name add index(substr(column_name,1,4));
Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of mysqli_num_rows?
What does the file with the extension: frm, myd, and myi contain?
How do you start MySQL on Linux?
What is blob and text in mysql?
What language is used in mysql?
What is the maximum size of mysql database?
What is mysqli_num?
What happens if you no create privilege in a database?
What is 'mysqlcheck'?
What causes mysql too many connections?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
What are the benefits of mysql?