Codeigniter Active Record with nested "SELECT WHERE"

Question

I was wondering if there was any way in Active Record to create a query with nested WHERE cases like:

SELECT * FROM Users WHERE FirstName = 'John' AND (LastName = 'Smith' OR LastName = 'Jones');

M Khalid Junaid · Accepted Answer · 2014-04-03 22:07:25Z

2

Yes you can use where() function

$this->db->select('*');
$this->db->from('Users ');
$this->db->where("FirstName = 'John'");
$this->db->where(" (LastName = 'Smith' OR LastName = 'Jones') ");
$result=$this->db->get();

Active Record

answered Apr 3, 2014 at 22:07

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

BrandonOHara Over a year ago

Thank you, that worked perfectly. I wasn't aware you could enter straight SQL like that in the where function.

Erico · Accepted Answer · 2014-04-03 22:11:16Z

0

You need to pass the WHERE clause in order to do this.

$this->db->where("FirstName = 'John' AND (LastName = 'Smith' OR LastName = 'Jones')");

answered Apr 3, 2014 at 22:11

Erico

1,47110 silver badges18 bronze badges

Collectives™ on Stack Overflow

Codeigniter Active Record with nested "SELECT WHERE"

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related