remove_russian_messages_in_prestashop.sql

-- Deleting all customer messages in prestashop written in Russian
-- Search for three most popular russian characters "о, е, а"

-- Deleting thread info from ps_customer_thread column
delete from
    ps_customer_thread
where
    id_customer_thread in (
        select
            id_customer_thread
        from
            ps_customer_message
        where
            (
                ps_customer_message.message like "%о%"
                OR ps_customer_message.message like "%е%"
                OR ps_customer_message.message like "%а%"
            )
    )


-- Deleting messages from ps_customer_message column
delete from
    ps_customer_message
where
    (
        ps_customer_message.message like "%о%"
        OR ps_customer_message.message like "%е%"
        OR ps_customer_message.message like "%а%"
    )