Database has_operator to support LIKE and SOUNDS LIKE

[dipunm]

I needed to use the SOUNDS LIKE function so I decided to put the operator in the array key with the field name and use the where function. For this to work, I had to modify the system\libraries\drivers\Database.php file [line 269] to:

return (bool) preg_match('/[<>!=]|(?:\s+SOUNDS\s+)?\s+LIKE\s*|\sIS(?:\s+NOT\s+)?\b/i', trim($str));

[Shadowhand]

SOUNDS LIKE is not a standard SQL operator.

[anonymous]

Milestone 2.1.3 deleted