Search by any part of a user name

question

[savil]

What should I modify in this script to do a search by any part of a user name and NOT by the whole username:

<?
$rs=@mysql_query("select * from usrinfo where UserName='$username'");
while ($ro=@mysql_fetch_array($rs)){
echo $ro[UserName];
}
?>

Thank You.

[tomda]

Not very clear, but try to use the like and % statement. It will check if the string_username are in the username.

e.g., if $string_username is 'bert' then the query will give you 'robert', 'albert' or 'berthe' or whatever with 'bert' in it.

$rs=@mysql_query("select * from usrinfo where UserName LIKE '%$string_username%'");

[savil]

Thank you tomda!
It worked :)