select some_data from some_table where pub_date>='' and pub_date<='';
to
select some_data from some_table where pub_date between '' and '';
select some_data from some_table where pub_date>='' and pub_date<='';
to
select some_data from some_table where pub_date between '' and '';