[eluser]danmontgomery[/eluser]
[quote author="InsiteFX" date="1301595456"]where_in does not take an array!
But you could use like which does take an Associative array.
InsiteFX[/quote]
where_in
only takes arrays...
Code:
$this->db->where_in('some_field', array(1,2,3,4));
[quote author="maf_9000" date="1301596961"]thanks Mr InsiteFX
i need to search in tags column in db with any element of the array $tags i have created
what is the syntax please[/quote]
There's no "like in" functionality in MySQL, you would have to use or_like, or manually construct a where() string.
Code:
$this->db->or_like('field', 'value_a');
$this->db->or_like('field', 'value_b');
// or
$this->db->where('(`field` LIKE "%value_a%" OR `field` LIKE "%value_b%")', NULL, FALSE);