SQL中的正则表达式以检测一位或多位数字 [英] regex in SQL to detect one or more digit

问题描述

我有以下查询:

SELECT * 
FROM  `shop` 
WHERE  `name` LIKE  '%[0-9]+ store%'

我想匹配表示'129387 store'的字符串，但是上面的正则表达式不起作用.为什么会这样?

解决方案

使用 SQL FIDDLE DEMO

输出

|         NAME |
|--------------|
| 129387 store |

I have the following query:

SELECT * 
FROM  `shop` 
WHERE  `name` LIKE  '%[0-9]+ store%'

I wanted to match strings that says '129387 store', but the above regex doesn't work. Why is that?

解决方案

Use REGEXP operator instead of LIKE operator

Try this:

SELECT '129387 store' REGEXP '^[0-9]* store$';

SELECT * FROM shop WHERE `name` REGEXP '^[0-9]+ store$';

Check the SQL FIDDLE DEMO

OUTPUT

|         NAME |
|--------------|
| 129387 store |

这篇关于SQL中的正则表达式以检测一位或多位数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！