Why I use wm_concat (column) functions query results, into a json object after I print the json is a null value, I print the query results query out the column is also have value, is this why? Pray god to help solve

CodePudding user response:

into a json object after I print the json is a null value,

What kind of transfer?

CodePudding user response:

Thank you, see my problem, has now been solved wm_concat (column) to wm_concat (to_char (column) thus done

CodePudding user response:

Mybatis fuzzy matching the same values of multiple fields
AND CONCAT (name, alias, address) LIKE '%' # {input box at the front desk value} '%'

Can write like this?
Can be ruled out match other is null and result in a query is not out of the question?