sshum Posted May 10, 2011 Share Posted May 10, 2011 Hello, I have a mysql table with over 1,000,000 postcodes, and I need to select chunks of them. Ive been using the LIKE which has been fine, ie WHERE `POST_CODE`LIKE 'LS%' but I have ran into a problem in I cant do that with postcodes starting with S, as there are postcodes like SE and SY etc. I was looking online and wondered if I needed to use a regular expression, and if so how do I do it? I need to select where the postcode starts with an 'S' and has a number after it. It doesn't matter about the rest of the postcode. Any help will be greatly appreciated. Cheers Quote Link to comment https://forums.phpfreaks.com/topic/236003-query-regexp/ Share on other sites More sharing options...
mikosiko Posted May 10, 2011 Share Posted May 10, 2011 http://dev.mysql.com/doc/refman/5.5/en/regexp.html lot of examples there Quote Link to comment https://forums.phpfreaks.com/topic/236003-query-regexp/#findComment-1213342 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.