MySQL正则表达式
SELECT column1, column2, ... FROM table_name WHERE columnN REGEXP pattern;
SELECT * FROM customers
WHERE 地址 REGEXP '12'
SELECT * FROM customers
WHERE 地址 REGEXP '12.'
SELECT * FROM customers
WHERE 地址 REGEXP '12|17'
SELECT * FROM customers
WHERE 地址 REGEXP '[京城道]'
SELECT * FROM customers
WHERE 地址 REGEXP '[3-9]'
版权声明:
作者:Curry
链接:http://cp.it-cxy.top/index.php/2024/10/07/mysql%e6%ad%a3%e5%88%99%e8%a1%a8%e8%be%be%e5%bc%8f/
来源:CorePress
文章版权归作者所有,未经允许请勿转载。
THE END
二维码
共有 0 条评论