How about if I want to only return postal codes that are like W1U 8JE not W13 0SU.
Because in this example I have W1 as the postal code and W13 is the other postal code On Tue, Apr 24, 2012 at 5:18 PM, Gary Smith <li...@l33t-d00d.co.uk> wrote: > On 24/04/2012 17:16, Gary Smith wrote: > >> http://dev.mysql.com/doc/**refman/5.0/en/string-** >> comparison-functions.html<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 >
