[RESOLVED] Wildcard Search

[neroag]

Hi Guys

Could someone tell me whats wrong with the following wildcard query please

$query="SELECT * FROM table WHERE $field = '$accno .% ' ";

Many thanx

[thorpe]

What is the . doing there?

$query="SELECT * FROM table WHERE $field = '$accno%'";

[neroag]

I must be having one of those days where i cant see for looking lol, Thanx,
I also came up with to do the job, lol

$query = "SELECT * FROM table WHERE $field LIKE '%$accno%' ";