示例:(该部分转载自http://blog.sina.com.cn/s/blog_872758480100xerh.html )
select field1 from table1
order by field1 is not null and filed1 != " desc
使用CI的一个示例:
$this->db->order_by("field1 is not null and field1 != '' desc, id desc");
示例:(该部分转载自http://blog.sina.com.cn/s/blog_872758480100xerh.html )
select field1 from table1
order by field1 is not null and filed1 != " desc
使用CI的一个示例:
$this->db->order_by("field1 is not null and field1 != '' desc, id desc");
转载于:https://my.oschina.net/syc2013/blog/181660