SQL

A certain piece of SQL needs to parse a json string in a field. However, the Chinese characters in it are also encoded and stored in a similar format.

u6e38u620f

The SQL statement is theoretically as follows

get_json_object(extends,'$.cate')='u6e38u620f'

However, the actual system execution involves layers of compilation processes. How many backslashes should be written to select the correct result?

The experimental conclusions are as follows:

Take N fields from the database, and then combine them together and use "," to separate the display. At first, I thought of using CONCAT() to process it, but it was troublesome. Unexpectedly, CONCAT_WS() was mentioned in the manual, which is very easy to use.