当前位置:网站首页>Can the values of multiple fields be judged at the same time in MySQL query
Can the values of multiple fields be judged at the same time in MySQL query
2022-07-22 17:33:00 【CSDN Q & A】
mysql Whether the values of multiple fields can be judged at the same time in the query
for example : At the same time, find out one_day,two_day,three_day,four_day For shift or off duty
Is there a simple way to realize , Because there are many fields to determine whether intelligence contains (' class ',' Cease '), Only some fields are written below , There will be a lot after writing
Current code :
select * from DY_GFYH_YG
where one_day IN (' class ',' Cease ') and one_day IN (' class ',' Cease ') and two_day IN (' class ',' Cease ') and three_day IN (' class ',' Cease ') and four_day IN (' class ',' Cease ') and five_day IN (' class ',' Cease ') and six_day IN (' class ',' Cease ')
边栏推荐
猜你喜欢
Recommendation of selected topics for completed topics of Electronic Information Engineering
广度优先遍历(Breath First Search)
How to reinstall win11 system online with one click?
Reading papers [6] autoassembly: learning augmentation strategies from data
ssrf漏洞攻击内网Redis复现
Unity postprocess screen post-processing
会议OA项目
牛客网刷题1【最小步数Fibonacci数列】
Win11 terminal administrator cannot open the solution
MVC mode and three-tier architecture
随机推荐
MySQL constraint_ Unique constraint
指令安排问题
Win11 terminal administrator cannot open the solution
1312. Minimum number of inserts to make a string a palindrome string
浏览器页面的渲染流程
报表设计工具FastReport Online Designer V2022.1新改变全介绍
MySQL constraint_ Self growth constraint_ auto_ increment
云主机性能测试方案
【C】 Branch and loop statements
一个注解实现方法返回数据写入缓存(切面、Redis实现)
关键路径实现
HCIP ospf接口网络类型实验报告
354. Russian Doll envelope problem
What if win11 encounters a problem and needs to restart?
-bash-4.2$
广度优先遍历(Breath First Search)
flinksql 的task可以监控是否中断吗?
Map insert element
会议OA项目
Share our first otherside trip