0
I have a query that returns some char type keys like this X-1, X-2, X-3. The problem is that now I need to use with where chaves in( ... ) and would have to format the values to
'X-1', 'X-2', 'X-3'. That would save me some relationships...
As this is all within the query, I cannot format with PHP, so I thought about creating a function in MYSQL for this purpose, but I don’t know which functions would use.
X-1, X-2, X-3 are keys concatenated with group_concat to play in the clause in( ... ), for this reason needed to format.
I think I solved with the function itself using parameters:
group_concat( '"' , chaves , '"' ):"X-1","X-2","X-3".– Papa Charlie
Didn’t work out as expected.
– Papa Charlie