SELECT DISTINCT n1.source_id label, IFNULL( tb.`value`, 0) `value`
from table n1
left join (
select source_id ,count(source_id) `value` from table
WHERE update_time >= NOW() - INTERVAL 1 DAY and source_id IN ('x','xx')
)as tb on n1.source_id = tb.source_id where n1.source_id IN ('x','xx')
二、分页查询过去24小时的数据
SELECT * FROM sp_news_domestic WHERE update_time >= NOW() - INTERVAL 1 DAY limit 4,2
select*from xxx where CHAR_LENGTH(subject_cn)=LENGTH(subject_cn)
五、分组查询
SELECT
a.*,
GROUP_CONCAT( b.file_name )FROM
xx a
LEFTJOIN fgstd_file_info b ON FIND_IN_SET(
b.id,REPLACE(REPLACE( a.file_info_id,'[',''),']',''))WHERE
b.id ISNOTNULLGROUPBY
a.id