PHP regular expressions with SELECT LIKE %

Question

For a few years, I have been happily using PDO debugger and recommend it highly.

I haven'f found anything better to help me debug my PDO SQL statements with bound parameters. It will show me the SQL statement which will be generated after bound parameters are substituted, which is A Good Thing.

I post the code below. My problem is that when I introduce a SELECT query using LIKE %gail.com, where $agencyEmailDomain == "gmail.com" and $expandedSqlCommand = PdoDebugger::show($sqlText, $parameters);

expanded to

SELECT count(*) AS count FROM recruiters WHERE recruiter_email LIKE "%'Gmail.com'"

Notice those single quotes around the domain name?

Is there something that I can do, like escaping the % sign?

My code is

$sqlText = 'SELECT count(*) AS count FROM recruiters 
            WHERE recruiter_email LIKE "%:agencyEmailDomain"';

$sqlParameters =  array('agencyEmailDomain' => $agencyEmailDomain);

and PDO-debugger's code is

/**
 * Class PdoDebugger
 *
 * Emulates the PDO SQL statement in an extremely simple kind of way
 */
class PdoDebugger
{
    /**
     * Returns the emulated SQL string
     *
     * @param $raw_sql
     * @param $parameters
     * @return mixed
     */
    static public function show($raw_sql, $parameters)
    {
        $keys = array();
        $values = array();

        /*
         * Get longest keys first, so that the regex replacement doesn't
         * cut markers (ex : replace ":username" with "'joe'name"
         * if we have a param name :user )
         */
        $isNamedMarkers = false;

        if (count($parameters) && is_string(key($parameters))) 
        {
            uksort($parameters, function($k1, $k2) 
            {
                return strlen($k2) - strlen($k1);
            });

            $isNamedMarkers = true;
        }

        foreach ($parameters as $key => $value) 
        {

            // check if named parameters (':param') or anonymous parameters ('?') are used
            if (is_string($key)) 
            {
                $keys[] = '/:'.ltrim($key, ':').'/';
            } 
            else 
            {
                $keys[] = '/[?]/';
            }

            // bring parameter into human-readable format
            if (is_string($value)) 
            {
                $values[] = "'" . addslashes($value) . "'";
            } 
            elseif(is_int($value)) 
            {
                $values[] = strval($value);
            } 
            elseif (is_float($value)) 
            {
                $values[] = strval($value);
            } 
            elseif (is_array($value)) 
            {
                $values[] = implode(',', $value);
            } 
            elseif (is_null($value)) 
            {
                $values[] = 'NULL';
            }
        }

        if ($isNamedMarkers) 
        {
            return preg_replace($keys, $values, $raw_sql);
        } 
        else 
        {
            return preg_replace($keys, $values, $raw_sql, 1, $count);
        }
    }
} 

How can I change to correctly handle that LIKE "%:agencyEmailDomain"?