Jump to content

sshum

New Members
 View Profile  See their activity

  • Posts

    1

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

sshum's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. sshum

    Query regexp?

    sshum posted a topic in MySQL Help

    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
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.