How to put the string b list out and then as a condition of the query to a table inside the query, such as the second row in the table b value is 1, 2, 3, 4, how to realize the select num from a where id in (1, 2, 3, 4) the effect, and then the query results, joining together in together,
Ultimate lookup table. A value of "1, 2, 3, 4"

CodePudding user response:

You can use the like

CodePudding user response:

Concat (', ', Anderson d, ', ') like concat (' %, 'b.n um,' % ')

CodePudding user response:

The concat (', ', b.n um, ', ') like concat (' %, Anderson d, '%')