Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


like and wildcard in doctrines findby


like and wildcard in doctrines findby  using -'mysql,codeigniter,doctrine'

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.
    

asked Sep 15, 2015 by JasmineVasse
0 votes
42 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...