论坛 › CodeIgniter 问答求助 › CI的AR如何写子查询?

longjianghu 发表于 2010-6-29 23:17:06

CI的AR如何写子查询?

本帖最后由 longjianghu 于 2010-6-30 09:01 编辑

比如下面的SQL语句:select uid,username from cdb_member where uid=(select pid from cdb_relation where uid=1 order by pid desc limit 1)

haohailuo 发表于 2010-6-30 10:06:25

CI的AR不支持，直接用sql语句吧，如

$sql = "";
$this->db->query($sql);

的形式就可以的

visvoy 发表于 2010-6-30 12:22:39

->db->select('uid,username');
->db->where('uid','(select pid from cdb_relation where uid=1 order by pid desc limit 1)',false);
->db->get('cdb_member');

longjianghu 发表于 2010-6-30 13:34:30

->db->select('uid,username');
->db->where('uid','(select pid from cdb_relation where uid=1 order by...
visvoy 发表于 2010-6-30 12:22 http://codeigniter.org.cn/forums/images/common/back.gif


   试试,谢谢!

soareyou 发表于 2015-8-4 17:14:51

->db->where('uid in (select pid from cdb_relation where uid=1 order by pid desc limit 1)',null,false);
完美解决

rainbyte 发表于 2015-8-5 17:16:00

唉.AR我又让觉得鸡肋了.既然混杂了纯sql,不如直接就用sql吧.

查看完整版本: CI的AR如何写子查询?