CAKEPHP 3: Like condion special character paginate

83 Views Asked by At

I'm having trouble finding likes with special characters as follows in the database i have a record with the name Toan"123 now, in cakephp 3 i use query ORM

$sqlSub = $sysLogTable
    ->find('all', [
        'fields' => array('id' ,'name')
        'conditions' => array("name LIKE" => "%Toan"%")
    ])
    ->toArray();

but I don't get Toan"123. How to get Toan"123 with sql above. Please help me, I'm stuck

0

There are 0 best solutions below