Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
4.1k views
in Technique[技术] by (71.8m points)

mysql表以key-value形式设计,怎么多条件查询?

如下图显示,想查询 keys字段里的值等于:name,num;和values字段里的值等于:web;范围大于等于2 小于等于5;但是如图的sql查不出数据,怎么办?
image


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

image.png
大哥你这写错了sql

select
* 
from `tp_teszt_kv`
where 
`key` in('name','num') 
and `value` = 'web' 
or 
(`value`>=2 and `value`<=5);

同一字段的多个条件还是要看清楚逻辑


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...