Selecting fields that are similar (fuzzy search)

[DragonHighLord]

A while back, I got some code to do a fuzzy search, but it works too great.

Here is what I have:

incoming variable for the search string they typed in is $search

$results = db_query( "select name from table_users where names LIKE '%$search%' ORDER BY RAND() LIMIT 1" );

ok, so if you type in "a" for your search. it will display any name in the table with an "a" in it, of course I want something that does a more exact search. Like if you just put "a" in, it wouldn't find anything

Any ideas as to what I can do?

[DragonHighLord]

I got it, I just made the strength length to the incoming variable to like 5 characters, so they have to research if they type in less than that