multiple keyword match with db_like

Question

I am using db_select for database query, following code works fine when $keyword is any string

 $result = db_select('my_table', 'mt') ->fields('mt') ->condition('my_column', '%' . db_like($keyword) . '%', 'LIKE') ->execute() ->fetchAllKeyed();

How can I make the same query working when $keyword is suppose to be an array of strings like ("del","mum") ,if my_column is location column so query will return me places like Delhi, Mumbai.

refer to drupal.stackexchange.com/questions/51089/… for a similar example. — junedkazi
– junedkazi, Commented Oct 10, 2013 at 21:21

Mike Vranckx · Accepted Answer · 2017-03-27 06:02:07Z

You can build your query while looping through each keyword and adding this as an OR condition.

$db_or = db_or(); $query = db_select('my_table', 'mt'); $query->fields('mt'); foreach ($keywords as $keyword) { $db_or->condition('my_column', '%' . db_like($keyword) . '%', 'LIKE'); } $query->condition($db_or); $results = $query->execute()->fetchAllKeyed();

Thanks! syntax error at $db_or->condition('my_column', '%' . db_like($keyword) . '%', 'LIKE')); extra ')' at the end. — Prashant Kanse
– Prashant Kanse, Commented Mar 26, 2017 at 17:40

Stack Exchange Network

multiple keyword match with db_like

1 Answer 1

Linked

Hot Network Questions

multiple keyword match with db_like

1 Answer 1

Linked

Related

Hot Network Questions