判断某个值是纯数字
REGEXP '[^0-9.]'
MySQL查询某个字段是纯数字:
select *,seller_user REGEXP '[^0-9.]' seller_user_type
from table_name
having seller_user_type = 0
判断某个值是纯数字
REGEXP '[^0-9.]'
MySQL查询某个字段是纯数字:
select *,seller_user REGEXP '[^0-9.]' seller_user_type
from table_name
having seller_user_type = 0