1 个人blog上总会有一些归档的列表,如
|
|
对于归档可以用如下sql: select count(*) as Total, replace(replace(convert(varchar(7),createdtime,120),'-0','-'),'-','年')+'月' as CreatedTime from tablename |
group by convert(varchar(7), createdtime,120)
order by convert(varchar(7), createdtime,120) desc
2 模糊搜索:
select * from tablename
where name like ’[a-zA-Z]%’ --------- ([]指定值的范围)
name like ’[^F-M]%’ --------- (^排除指定范围)
lastName+firstName like '张三' ------(将两个字段组合起来查询)
name like 'A__' --------------------------(查询以A开头,长度为三个字符的内容)