LIKE and % Wildcard in Doctrine's findBy*()

codeigniter, doctrine, mysql

Solution

$users = Doctrine::getTable('User')->createQuery('u')
  ->where('column_name3 LIKE ?', '%search_key%')
  ->execute();

Problem

How do I write the following MySQL query using Doctrine's findBy*() method?: ``` SELECT column_name1, column_name2 FROM table_name WHERE column_name3 LIKE '%search_key%'; ``` For Example, to fetch multiple rows from a column named "ColumnName" (below) using Doctrine: ``` $users = Doctrine::getTable('User')->findByColumnName('active'); echo $users[0]->username; echo $users[1]->username; ``` I tried: ``` $search_key = 'some value'; $users = Doctrine::getTable('User')->findByColumnName('%$search_key%'); echo $users[0]->username; echo $users[1]->username; ``` and I got no errors, but nothing displayed. Any assistance will be really appreciated. Thanks in advance.

Original source