Mysql查询,注释/* */ #
1.查询所有医院类关键词
SELECT * FROM `cms_keywords_seo` where cate_id in(11,62)
2.查询
SELECT * FROM `cms_keywords_seo` where cate_id=11 AND sub_cate=4
3.查询二级分类为空字段
SELECT * FROM `cms_keywords_seo` where sub_cate is NULl;
4.查询医院类副主类关键词空(4461)
SELECT * FROM `cms_keywords_seo` where cate_id in(11,62) AND sub_cate is NULl;
5.医院类关键词主类关键词cate_id =11,副主类关键词空(1119条)
SELECT * FROM `cms_keywords_seo` where cate_id =11 AND sub_cate is NULl;
6.医院类主类关键词cate_id =62,副主类关键词空空(3342)条
SELECT * FROM `cms_keywords_seo` where cate_id =62 AND sub_cate is NULl;
7.查询非医院类默认含价格分类
SELECT * FROM `cms_keywords_seo` where cate_id in (1,14)
and (keyword like'%钱%' OR keyword like'%费用%' OR keyword like'%价格%');
8.根据id降序排序
SELECT * FROM `cms_keywords_seo` where cate_id in (1,14)
and (keyword like'%钱%' OR keyword like'%费用%' OR keyword like'%价格%')
ORDER BY id DESC;
9.医院评论
SELECT * FROM `cms_keywords_seo` where cate_id IN(11,62)
and (keyword like'%怎么样%' OR keyword like'%如何%')
ORDER BY id DESC;
10.查询非医院默认字段,不含价格字段
select * from `cms_keywords_seo`
where id not in
(SELECT id FROM `cms_keywords_seo` WHERE (keyword like '%钱%' or keyword like '%费%' or keyword like '%价%'))
order by id
11. 查询多个范围
select * from 表名 where id in (1,2,5) 或者 select * from 表名 where id=1 or id=2 or id=5
12.查询网友关注
SELECT * FROM `cms_keywords_seo`
where cate_id in(11,62)
AND sub_cate in(4,6,7,8)
and keyword not in(SELECT keyword FROM `cms_keywords_seo`
where keyword LIKE"%钱%" or keyword LIKE"%价%" or keyword LIKE"%费%"
or keyword LIKE"%怎么样%" or keyword LIKE"%如何%" or keyword like"%排名%");
13.如何mySql查询
数据库前10条
记录SELECT id FROM `cms_keywords_seo` ORDER BY id asc LIMIT 10
14.如何组合12、13查询
SELECT * FROM `cms_keywords_seo`
where cate_id in(11,62)
AND sub_cate in(4,6,7,8)
and keyword not in(SELECT keyword FROM `cms_keywords_seo`
where keyword LIKE"%钱%" or keyword LIKE"%价%" or keyword LIKE"%费%"
or keyword LIKE"%怎么样%" or keyword LIKE"%如何%" or keyword like"%排名%")
LIMIT 10
15.根据排序限制查询10条记录
SELECT * FROM `cms_keywords_seo`
where cate_id in(11,62)
AND sub_cate in(4,6,7,8)
and keyword not in(SELECT keyword FROM `cms_keywords_seo`
where keyword LIKE"%钱%" or keyword LIKE"%价%" or keyword LIKE"%费%"
or keyword LIKE"%怎么样%" or keyword LIKE"%如何%" or keyword like"%排名%")
ORDER BY sub_cate desc LIMIT 10
16.表连接查询
SELECT a.HOSP_ORDERNUM as 预约数,b.HOSP_NAME 医院名称,b.HOSP_ID 医院id
FROM `HOSP_ORDERNUM_COUNT` a LEFT JOIN HOSP_HOSPITAL b on a.HOSP_ID=b.HOSP_ID
WHERE b.HOSP_ID=1;