The reason why the Json_encode field cannot be obtained through fuzzy query in mysql and the Solution

In the project, you need to search for a large text field. The result shows an interesting problem. The fuzzy match mode such as % LIKE % was used, the two strings must be exactly the same before they can be matched. Then, the two strings are output and compared. It is found that there is one pair of double quotation marks at both ends of the strings that have been encoded before the query, the value of database fields also has double quotation marks at both ends, but when they are not the same, the positions of the quotation marks are different. This is the cause of fuzzy match failure, the solution is also simple. You only need to perform the double quotation marks removal operation after the passed value is json_encode.