FYI: We constructed a relatively simple query which is at the moment good enough for our needs:
SELECT
id, user_id, topic_id, post_number, cooked, raw
FROM posts p
WHERE cooked ~* ‘.*■’
With results:
One of SQL Wizzzards of Ours is constructing a far more sophisticated query, that finds exact position of censored word. It kinda works, but he keeps on grumbling that raw and cooked are not of the same length…which gives us a new appreciation of just how difficult is to store and especially to manage the results of what was found by watched words.