[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