How to parametrize a query using an array (WHERE field IN (...)?

Question

MySQL

"SELECT * FROM testimony WHERE Name IN('" + "Record 1" + "','"+ "Record 2" + "')" works. How to make the values ​​loaded from an array (array)?
The array itself:
string[] array = new string[] { "Record 1", "Record 2" };

Answer 1

https://stackoverflow.com/questions/2377506/pass-a...

Answer 2

Create a type in the database

CREATE TYPE [dbo].[TableValueType] AS TABLE(
  [value] varchar(50) NOT NULL
)

Then in code

var tableParam = new SqlParameter("@paramName", SqlDbType.Structured);
tableParam.TypeName = "[dbo].[TableValueType]";
tableParam.Direction = ParameterDirection.Input;
// Установка значений
var rows = new List<SqlDataRecord>();
var sqlMetaData = new SqlMetaData("value", SqlDbType.VarChar);
foreach (var value in values)
{
      var row = new SqlDataRecord(sqlMetaData);
      row.SetValues(value);
      rows.Add(row);
}
tableParam.Value = rows;

And the request will look like

SELECT * FROM testimony WHERE Name IN (select [value] from @paramName)

PS: Oops! The tag turns out to be MySql, and this solution is for MSSQL