search

johngodley / search-regex

Search Regex adds a powerful set of search and replace functions to WordPress that go beyond the standard searching capabilities, with full regex support.
https://searchregex.com
GNU General Public License v3.0
32 stars 9 forks source link

Search Regex Query Error #167

Open Estalhun opened 1 year ago

Estalhun commented 1 year ago 
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 commented 1 year ago

Can you give more context?

Estalhun commented 1 year ago

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?