How to Pass Array of Strings to IN clause in Mysql

Databases
1

Hi I need to pass Array of strings to IN clause in mysql .

This works fine …
select * From tb_test Where letters In(‘A’,‘B’,‘C’);

But when i concatenate it into a variable and execute it ,i am not getting the output.can anyone please help me on this .

set @param_letters=‘’‘A’‘,’‘B’‘,’‘C’‘’;
select * From tb_test Where letters In(select @param_letters);

2

Is the array of strings coming from PHP?

If yes, then you can use implode() to create the “in” part of your sql query

3

No its not from PHP . I am passing the array of strings from VB application to Stored procedure.
i need to work around with this logic in Mysql only .
@param_letters is a stored procedure parameter which contains a dynamic string like these @param_letters=" ‘A’,‘B’,‘C’ " .

i need to pass @param_letters to IN clause statement . select * From tb_test Where letters In(select @param_letters);