Slim + NotORM, select %Like%

Question

I just started to use the Slim framework + NotORM_ and need to do the following:

SELECT * FROM Users WHERE name LIKE '%$value%'"

In Slim I can select the exactly matching rows using

$p = $db->Users()->where('name', $value) as $p)

I would appreciate if someone show me the right solution to my problem

Answer 1

You can provide the like keyword in your query with a wildcard, and add the % signs before and after your search term in PHP like this:

$p = $db->Users()->where('name like ?', "%$value%")

Answer 2

where_like('DataFieldName','%'Query'%')