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 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 Link to comment https://forums.phpfreaks.com/topic/236003-query-regexp/#findComment-1213342 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.