欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

between and-mysql between...and 查询结果多于期望数据的问题

程序员文章站 2022-05-17 09:39:05
...
mysqlbetween and

sql语句:
SELECT * FROM card where number between 'Z101010768' and 'Z101010772'
查询结果:
between and-mysql between...and 查询结果多于期望数据的问题
其实我只是想查 'Z101010768' 'Z101010769' 'Z101010770' 'Z101010771' 'Z101010772'
这5个数据而已
请教怎么处理一下????

相关标签: mysql between and