I have a query that returns some CHAR type keys like this X-1, X-2, X-3
. The problem is that I now need to use with where chaves in( ... )
and would have to format the values for
'X-1', 'X-2', 'X-3'
. This would save me some relationships ...
As this is all within the query, I can not format with PHP, so I thought about creating a function in MYSQL for this purpose, but I do not know what functions it would use.
X-1, X-2, X-3
are keys concatenated with group_concat
to play in the in( ... )
clause, so you needed to format.