XPDO Query with LIKE, Session Variable and Percentage wildcard

85 Posts

mflammia Reply #1, 13 years, 8 months ago

Apologies if this is a simple one but have tried as many variations as I can think of but can get this to work.

What I trying to do is simply run the query

SELECT * 
FROM  `DestinationNames` 
WHERE number LIKE  '019%'

Where the 019 is going to be a session varable.

My query curretnly looks like this

$c = $modx->myDB->newQuery('DestinationNames');
$c->where(array('Number:LIKE' => $_SESSION['searchResult']));

Which works fine, but I don't know how to introduce the percentage?

Thanks in advance.

This question has been answered by opengeek. See the first response.

discuss.answer

MODX Staff
10,725 Posts

opengeek Reply #2, 13 years, 8 months ago

$c = $modx->myDB->newQuery('DestinationNames');
$c->where(array('Number:LIKE' => $_SESSION['searchResult'] . '%'));

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

85 Posts

mflammia Reply #3, 13 years, 8 months ago

Much appreciated opengeek.

Answered XPDO Query with LIKE, Session Variable and Percentage wildcard