MySQL: Selecting a username?
View Single Post
11-26-2007, 09:04 AM
Join Date: Nov 2007
Location: according to my wife: on the Net
If you know your way around MySQL, you can create an index on a part of a column so you can actually index the first three or four characters (do mind yourself you cannot make this an unique index)
The statement shown here creates an index using the first 4 characters of the name column:
CREATE INDEX part_of_name ON customer (name(4));
View Public Profile
Send a private message to DragonBe
Visit DragonBe's homepage!
Find More Posts by DragonBe