KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm producing a query like the following using ActiveRecord SELECT * FROM (`foods`) WHERE `type` = 'fruits' AND `tags` LIKE '%green%' OR `tags` LIKE '%blue%' OR `tags` LIKE '%red%' The number of tags and values is unknown. Arrays are created dynamically. Below I added a possible array. $tags = array ( '0' => 'green'. '1' => 'blue', '2' => 'red' ); Having an array of tags, I use the following loop to create the query I posted on top. $this->db->where('type', $type); //var type is retrieved from input value foreach($tags as $tag): $this->db->or_like('tags', $tag); endforeach; The issue: I need to add parentheses around the LIKE clauses like below: SELECT * FROM (`foods`) WHERE `type` = 'fruits' AND (`tags` LIKE '%green%' OR `tags` LIKE '%blue%' OR `tags` LIKE '%red%') I know how to accomplish this if the content within the parentheses was static but the foreach loop throws me off..
Tags (comma-separated)
Save Edits
Cancel