[thelist] Mysql regexp

Paul Bennett Paul.Bennett at wcc.govt.nz
Thu Feb 7 19:05:13 CST 2008


Hi all,

Looking for the correct syntax for a regexp pattern in mysql.

I want to: select records which have zero or more alpha characters then one instance of the match (a search term) followed by zero or more alpha chars followed by a comma.

Am I even getting close with this: 
select `Full Client Name` from Interments where `Full Client Name` regexp '^[a-z]{0,}+"smith"+[a-z]{0,}\,+$'

??

Any help welcome :)
Paul 


The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated.



More information about the thelist mailing list