Active Record - where_in AND or_like

[eluser]WanWizard[/eluser]
To alter the selection order of the where clause you need to use brackets:

Code:

SELECT * FROM (`items`) WHERE `category_id` IN ('7', '43') AND (`id` LIKE '%TK%' OR `item_code` LIKE '%TK%')

Search the forum, I posted an DB_active_rec.php extension that introduced a method to add brackets to an active record query...