Httqm's Links
I "like" it ;-)

Basically, same syntax as in MySQL :

SELECT
count(1)
FROM
schema.table
WHERE
column LIKE '%pattern%';
(Permalink)