Jump to content


This topic is now archived and is closed to further replies.


*SOLVED* MySQL and Regular Expressions

Recommended Posts

[!--quoteo(post=361137:date=Apr 3 2006, 08:44 AM:name=bowenbowen)--][div class=\'quotetop\']QUOTE(bowenbowen @ Apr 3 2006, 08:44 AM) [snapback]361137[/snapback][/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.

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

LIKE '%#ZI%"

that seems to work fine.

Share this post

Link to post
Share on other sites


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.