Search Regex Query Error

[Estalhun]

SELECT COUNT(wpmy_postmeta.meta_id) AS match_rows FROM wpmy_postmeta WHERE wpmy_postmeta.meta_key LIKE BINARY '\\_elementor\\_data' AND (wpmy_postmeta.meta_key LIKE BINARY '%💊%' OR wpmy_postmeta.meta_value LIKE BINARY '%💊%')

[johngodley]

Can you give more context?

[Estalhun]

Hi John,

Of course. I tried to replace the 💊 character to 💊
Every SQL table has utf8mb4_unicode charset and utf8mb4_unicode_ci collation.

That's all.
Estal

Can you give more context?