SELECT t_meter_s.eneid,eneval,time,enedesc,enetype, substring_index(enedesc,’##’,1) AS first_level,
REPLACE(REPLACE(substring_index(enedesc,’##’,2),substring_index(enedesc,’##’,1),’’),’##’,’’) AS second_level, REPLACE(REPLACE(substring_index(enedesc,’##’,3),substring_index(enedesc,’##’,2),’’),’##’,’’) AS third_level, REPLACE(REPLACE(substring_index(enedesc,’##’,4),substring_index(enedesc,’##’,3),’’),’##’,’’) AS forth_levelFROM t_meter_s,t_enefr_configWHERE SUBSTRING(t_meter_s.eneid,1,’
c
o
u
n
t
′
)
=
′
{count}') = '
count′)=′{ene_id}‘AND enetype = ‘${enetype}’
AND ( ( enetype = ‘01’
AND DATE_FORMAT(TIME,’%y-%m%d’)=DATE_FORMAT(NOW(),’%y-%m-%d’) )
OR ( enetype = ‘10’ AND DATE_FORMAT(TIME,’%y-%m’) = DATE_FORMAT(NOW(),’%y-%m’) )
OR ( enetype = ‘11’ AND DATE_FORMAT(TIME,’%y’) = DATE_FORMAT(NOW(),’%y’) ) )
AND t_meter_s.eneid = t_enefr_config.eneid;
sql语句where条件判断
最新推荐文章于 2024-07-29 03:59:40 发布