How does mysql search for emoticons?

expression I use urlencode encoding to get % F0%9F%98%8A . Now I want to write a sql statement to find out the data that contains this expression in the field directly. The utf8mb4 code used in the database table, I don"t know how to write sql

.
select * from comment where content like "%\xf0\x9f\x98\x8a%";

I wrote this. I can"t find the data, but there must be some data

.
Mar.24,2021

is still the same query. How to look it up? like% F0% 9F%% 98%% 8A%, and the escape in the middle will do the% escape and write%

.
Menu