Active Record: Brackets in WHERE/HAVING clauses

[eluser]mradlmaier[/eluser]
Hi All,

As far as I can see from the documentation, there is no easy way to use brackets in the WHERE or HAVING clauses to control precedence of multiple column criteria?

For example:

Code:

SELECT * FROM tbl1 WHERE col1 = 'abc' AND col2 = 'edf' OR col3 = 'ghi'

is not the same as

Code:

SELECT * FROM tbl1 WHERE col1 = 'abc' AND (col2 = 'edf' OR col3 = 'ghi')

Or did I miss something?

Michael

[eluser]TheFuzzy0ne[/eluser]
Pass FALSE in as the third parameter to prevent escaping:

Code:

$this->db->where('col1', 'abc', FALSE);

The almighty user guide says:

$this->db->where() accepts an optional third parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks.

Code:

$this->db->where('MATCH (field) AGAINST ("value")', NULL, FALSE);