MySQL 正则表达式

查找name字段中以‘ok‘为结尾的所有数据：

<span class="pln">mysql<span class="pun">><span class="pln"> SELECT name FROM person_tbl WHERE name REGEXP <span class="str">‘ok$‘<span class="pun">;</span></span></span></span></span>

查找name字段中包含‘mar‘字符串的所有数据：

<span class="pln">mysql<span class="pun">><span class="pln"> SELECT name FROM person_tbl WHERE name REGEXP <span class="str">‘mar‘<span class="pun">;</span></span></span></span></span>

查找name字段中以元音字符开头且以‘ok‘字符串结尾的所有数据：

<span class="pln">mysql<span class="pun">><span class="pln"> SELECT name FROM person_tbl WHERE name REGEXP <span class="str">‘^[aeiou]|ok$‘<span class="pun">;</span></span></span></span></span>

MySQL 正则表达式

标签：