Searching for exact term or no result

[pquinn]

Hello folks,

First time posting here and I am hoping some of you fine people could help me with a problem I am having.

I have a full text search box that if I type even the letter 'j' it will pull in every record with the letter 'j'.

Basically I cant figure out how to search for a term and only that term so if I type 'joe blogs' joes record will appear and if i type 'j' nothing will appear.

My apologies as I cant think of how to explain it.

The code I am using at the moment is:

//Search Query
$sql = mysql_query("SELECT * FROM UserList WHERE Name like '%$search%'");

Many Thanks,

Peter

[x34cha]

Originally Posted by pquinn

Hello folks,

First time posting here and I am hoping some of you fine people could help me with a problem I am having.

I have a full text search box that if I type even the letter 'j' it will pull in every record with the letter 'j'.

Basically I cant figure out how to search for a term and only that term so if I type 'joe blogs' joes record will appear and if i type 'j' nothing will appear.

My apologies as I cant think of how to explain it.

The code I am using at the moment is:

//Search Query
$sql = mysql_query("SELECT * FROM UserList WHERE Name like '%$search%'");

Many Thanks,

Peter

Probably a bit of a random guess, I'm new to PHP too, but where it says "name like" change it just to "name"

[pquinn]

lol now that does make me feel stupid, worked perfectly Thanks for helping

[x34cha]

Originally Posted by pquinn

lol now that does make me feel stupid, worked perfectly Thanks for helping

Hehe, no problem, sometimes common sence is all that is neccessary.

[valera]

I have the same problem. Could you let me know how did you solved it? Thanks

[Fou-Lu]

You simply change the WHERE condition to not use like.

WHERE Name LIKE '%j%'
// becomes
WHERE Name = 'j'

This of course has nothing to do with PHP as this is a SQL issue in search criteria.