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
.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%
.Previous: Doubts about the separation of reading and writing on a single mycat computer
Next: Spring-data-mongodb uses MongoTemplate to realize paging query and error report
1 br Nodejs inserts data into the data 2mysqlutf8mb43, the front end uses react+redux, 4. I guess the problem lies in the character encoding here ....