Re: Postal code searching

[Gary Smith]

On 24/04/2012 17:16, Gary Smith wrote:
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
Specifically, replace % with _ as this means "match one character" not 
"match any number of characters". So, you can do:

like "W1 %"
like "W1_ %"
etc.
Oh, and you can also get really dirty and start using string functions 
like left() and so on.

Gary

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql