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 |
How do I uninstall mysql connector?
How to enter numeric values as hex numbers?
Can varchar be primary key?
How to insert dynamic values in mysql using php?
How do I setup mysql?
How to create table with same structure of student table in mysql?
What is innodb_buffer_pool_size?
what is JOIN? Give example & types of join?
14 Answers iMedia, Millennium, RAM Software, Satyam,
Why do we use group by and order by function in mysql?
How do I find my mysql username and password?
Can we write procedure in mysql?
Are stored procedures precompiled?
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)