![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
zy1110xz
这个作者很懒,什么都没留下…
展开
-
mysql查询中带空格
SELECT * FROM `test` WHERE `id` = '123' 无空格正常查询结果SELECT * FROM `test` WHERE `id` = '123 ' 字符串后面加空格正常查询结果SELECT * FROM `test` WHERE `id` = ' 123' 字符串前面加空格结果为空...原创 2019-01-03 12:16:49 · 2012 阅读 · 0 评论 -
mysql字符串类型的数字大小比较
SELECT a.* FROM test a WHERE left(a.probability,length(a.probability)-1) > 90 SELECT a.* FROM test a WHERE left(a.probability,length(a.probability)-1) > '90'a.probability = '100%'结果不...原创 2019-01-09 15:09:03 · 9893 阅读 · 0 评论