[SOLVED] SEARCH

[jaymc]

I am creating a postcode lookup tool, Im just wondering how to combat this little problem I have

 

A postcode comes in this structure

 

L12 8AK

 

And thats how its stored in the database

 

If someone types there postcode like this  L128AK it will return 0 results

 

The obvious is to have a tool tip or something giving them the format, but to go one further, how can I make mysql find the match regardless of whether they have entered a space demonstrated above

[fenway]

You should simply do the comparison on a trimmed field value -- e.g. with replace().

[jaymc]

Thanks, worked fine