sql语句查询日期 持续更新

1、查询某一天的数据

select * from SJ_ZCFG_CQ where lrsj =to_date('2016-4-28','yyyy-mm-dd');

2、查询时间段的数据

select * from SJ_ZCFG_CQ where lrsj between to_date('2016-4-1','yyyy-mm-dd') and to_date('2016-4-28','yyyy-mm-dd');

3、模糊查询

select id from SJ_ZCFG_CQ where title like '%关于议定书生效执行的公告.%'

4、更新某一个字段的多多条语句 

update wsfk set yxbz='N' where gdxh='100232113200' and xmdm in ( '1001', '1002', '1003', '1004', '2001', '2002', '2003', '2004', '2005')