Jump to content


Photo

*SOLVED* MySQL and Regular Expressions


  • Please log in to reply
No replies to this topic

#1 bowenbowen

bowenbowen
  • Members
  • Pip
  • Newbie
  • 8 posts
  • LocationIpswich, Suffolk, UK

Posted 03 April 2006 - 07:55 AM

[!--quoteo(post=361137:date=Apr 3 2006, 08:44 AM:name=bowenbowen)--][div class=\'quotetop\']QUOTE(bowenbowen @ Apr 3 2006, 08:44 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
I need to match a string in my field in my table, which would look something like this

8m/Ma1#ZI A26

All the fields have the same format. I face problems when I need to extract every field with the ZI letters in after the hash. I am guessing I need a regular expression to only match anything after the hash, can someone help me out with this.

Any help would be appreciated.
[/quote]

Forget this, I was being stupid, I can just use

LIKE '%#ZI%"

that seems to work fine.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users