如何检查 MySQL 中的值是否为整数?

2021-11-20 00:00:00 mysql

我看到在 MySQL 中有 Cast() 和 Convert() 函数可以从值创建整数，但是有没有办法检查一个值是整数吗?我正在寻找像 PHP 中的 is_int() 之类的东西.

I see that within MySQL there are Cast() and Convert() functions to create integers from values, but is there any way to check to see if a value is an integer? Something like is_int() in PHP is what I am looking for.

推荐答案

我假设您要检查字符串值.一种不错的方法是 REGEXP 运算符，将字符串与正则表达式匹配.简单做

I'll assume you want to check a string value. One nice way is the REGEXP operator, matching the string to a regular expression. Simply do

select field from table where field REGEXP '^-?[0-9]+$';

这相当快.如果您的字段是数字，只需测试

this is reasonably fast. If your field is numeric, just test for

ceil(field) = field

相反.

相关文章