sql查询记录

 代码一

select aid, atitle, author, sendauthor,atime, urlpath  from lzm_article 

where (author like '%鲁文%'  or author like '%鲁 文%')
 and  atime between  '2012/01/01' and '2012/03/31'

 

代码二 

select aid, atitle, author, sendauthor,atime, urlpath  from lzm_article 
where  author like '%鲁文%'  or author like '%鲁 文%'

 and  atime between  '2012/01/01' and '2012/03/31' 

 

 

posted @ 2012-03-31 09:35  zxlin25  阅读(128)  评论(0)  编辑  收藏  举报