*SOLVED* MySQL and Regular Expressions

[bowenbowen]

[!--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.