Create function for formatting (X-1, X-2, X-3) for ('X-1', 'X-2', 'X-3')

0

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.

    
asked by anonymous 03.02.2015 / 21:43

0 answers