CodeIgniter query WHERE column is one of two values and another column is one of two values

Question

I have for example this query:

SELECT *
FROM example
WHERE (column_1 = 1 OR column_1 = 2)
    AND (column_2 = 12 OR column_2 = 3)

How can I write it on Codeigniter?

I think something like:

$where = column_1 = 1 OR column_1 = 2;
$this->db->where($where);
$where2 = column_2 = 12 OR column_2 = 3;
$this->db->where($where2);

(I need to separate between each AND)

Is this ok? I don't have an idea how I can see the query as string only.

Topically relevant: Build a CodeIgniter query with a combination of AND and OR conditions in the WHERE clause and Codeigniter query to correctly encapsulate AND and OR conditions in a WHERE clause and Pass an array of diverse WHERE conditions as an array from the Controller to the Model in a CodeIgniter application — mickmackusa
– mickmackusa ♦, Commented May 29 at 9:17

Hnatt · Accepted Answer · 2011-07-17 15:13:31Z

1

If I got you right, you need something like this:

$this->db->where("(column_1 = 1 OR column_1 = 2) AND (column_2 = 12 OR column_2 = 3)");

Or what are you trying to achieve?

answered Jul 17, 2011 at 15:13

Hnatt

5,9533 gold badges34 silver badges43 bronze badges

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

Comments

michal.jakubeczy · Accepted Answer · 2018-12-13 08:10:31Z

0

Use where_in.

$this->db->where_in('column_1', array(1, 2));
$this->db->where_in('column_2', array(2, 13));

It will be easier to read.

answered Dec 13, 2018 at 8:10

michal.jakubeczy

9,7771 gold badge71 silver badges84 bronze badges