当前位置:Gxlcms > 数据库问题 > MySQL 正则表达式

MySQL 正则表达式

时间:2021-07-01 10:21:17 帮助过:36人阅读

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

  1. <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‘字符串的所有数据:

  1. <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‘字符串结尾的所有数据:

  1. <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 正则表达式

标签:

人气教程排行