Jump to content

Archived

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

bowenbowen

*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.
[/quote]

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.