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 |
Is postgresql better than mysql?
How do I find the size of a mysql database?
What does mysqli stand for?
How do I grant privileges to a user in mysql phpmyadmin?
How you will show all data from a table.
How to display odd rows in student table in mysql?
How do I kill a mysql connection?
What is the use of indexing table?
Explain MySQL optimization?
How to include numeric values in sql statements?
Why myisam is faster than innodb?
How many ways we can we find the current date using MySQL?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)