[Resolved] Query MySql database for a precise string

rupertbj

I have the fllowing query:

$sql = "SELECT * FROM av WHERE postcode LIKE '%$pc%' AND areasf <= '$maxarea' AND areasf >= '$minarea' ORDER BY areasf ASC";

However, in my database I have two similar entries of $pc - E1 and SE1. The trouble is that when I search for strings returning a value of E1, I do not want it to include SE1. Is there a way of searching for a precise string only?

Many thanks in advance for your help.

Rupert

zhabala

I don't know whether I understand correctly, but you can use normal equal statement:

$sql = "SELECT * FROM av WHERE postcode = '$pc' AND areasf <= '$maxarea' AND areasf >= '$minarea' ORDER BY areasf ASC";

but then it will return just those records where the postcode = $pc

$sql = "SELECT * FROM av WHERE postcode LIKE '$pc%' AND areasf <= '$maxarea' AND areasf >= '$minarea' ORDER BY areasf ASC";

to return records which begins with $pc

Zdenek

rupertbj

Thanks, BUT....
This is the code I have now....

$sql = "SELECT * FROM av WHERE postcode = '$pc' AND areasf <= '$maxarea' AND areasf >= '$minarea' ORDER BY areasf ASC";

and it still returns the entries with SE1 as well as E1.

Have a look at www.hexellwylie.com/search_av.php and you will see that when selecting a search with E1 selected, a record with SE1 is also returned.

Your further toughts? I have been trying all the combinations I can think of, but I must be missing something, no?

zhabala

It is immposible, could you post here a bit large part of your current PHP code, where the SQL command is ?

Zdenek

rupertbj

Yes, I thought it was impossible too! and now I see why. I had some if statements as well which I didn't post to keep things simple........and I forgot to change them too!!!

All is well now! Thanks for the help!