[转]mysql 对utf8编码 中文排序
SELECT * FROM `m` order by convert(name using gbk) asc;
eg:
select DISTINCT(b.id),b.ach_name,b.ach_bussiness,b.ach_finish_date,b.ach_finish_unit ,m.areaid,a.areaname from
(
select id,ach_name,thumb,ach_bussiness,ach_finish_unit,ach_entrust_unit,ach_finish_date,user_id,ach_delivery_type,ach_inn_small_classid,rtime from
ac_achievement where is_pass=1 limit 0,10
) b,ac_member m,ac_area a
where b.user_id = m.userid and m.areaid=a.areaid
order by convert(a.areaname using gbk) desc
- 上一篇：[转]jquery图片翻牌效果
- 下一篇：[转]tagcloud标签云
精彩图集
精彩文章