On 24/04/2012 17:24, Tompkins Neil wrote:
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
Then you'd do:
like 'W1 %' to return anything starting W1
like 'W13 %' to return anything starting W13.
like 'W1U %' to return anything starting W1U.
It's the location of the space before the wildcard that's important
here. The space is taken as part of the known element of the string.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql