TalkPHP - View Single Post

WinSrev · 11-25-2007, 09:42 PM

Hey,

I've been trying to figure out just what would be the quickest way to selecting a username from a database, there's no chance of selecting through fulltext as some usernames are less than 3/4 characters and to me the standard select could be slow with a lot of members. It has to be selected as a username to get the ID.

Anyone have any other suggestions?
Thanks!

11-25-2007, 09:42 PM	#1 (permalink)
WinSrev The Acquainted Join Date: Sep 2007 Posts: 133 Thanks: 6	MySQL: Selecting a username? Hey, I've been trying to figure out just what would be the quickest way to selecting a username from a database, there's no chance of selecting through fulltext as some usernames are less than 3/4 characters and to me the standard select could be slow with a lot of members. It has to be selected as a username to get the ID. Anyone have any other suggestions? Thanks!