时间:2021-07-01 10:21:17 帮助过:36人阅读
查找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 正则表达式
标签: