[PHP-DB] Mysql PDO statement with params in HAVING problem

Hi everyone, im new here, so please correct me if i created or formated topic incorrectly. I found a problem. I have a simple query for my needs: $stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as full_name,t.* FROM `specialists` `t` HAVING full_name like '%john%');

Re: [PHP-DB] Mysql PDO statement with params in HAVING problem

$stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as full_name,t.* FROM `specialists` `t` HAVING full_name like '%:query%'); How about '%:$query%' instead of '%:query%' ? Does that solve the problem? Thanks, On Thu, Jun 27, 2013 at 5:21 PM, Alexander Pletnev

[PHP-DB] Re: Mysql PDO statement with params in HAVING problem

On 6/27/2013 7:51 AM, Alexander Pletnev wrote: Hi everyone, im new here, so please correct me if i created or formated topic incorrectly. I found a problem. I have a simple query for my needs: $stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as full_name,t.* FROM