[RESOLVED] Get a specific list of postcodes with MySQL Like Operator

#native_company# #native_desc#

#native_cta#

This site is best viewed in a modern browser with JavaScript enabled.

[RESOLVED] Get a specific list of postcodes with MySQL Like Operator

nitapita

Hi everyone.

I have list of postcodes. And what i'm trying to do is get a listing of similar poscodes only.

My Code:

$postcode1 = ereg_replace('[^A-Za-z]', '', $postcode);

SELECT * FROM coverparked WHERE postcode LIKE '$postcode1%' ORDER BY postcode

So then $postcode1 strips all number from postcode, so for example E16 is strpped down to E only, then using the mysql query i get all the postcodes from database starting with E, problem is that i also get listing of postodes starting with EC, EN ... and i want postcodes sarting with E only.

Tried some options but i can't get to make it work..

Can you help me out here please ..

Thanks a lot in advance in advance.

ZABI

hope the following works for you

mysql_query("SELECT * FROM coverparked WHERE postcode regexp '^{{$postcode1}[0-9]{1,}'} ORDER BY postcode");

also read here http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html

nitapita

Thanks a lot ZABI - works perfect ...