Use mysql implode function in VB.NET (how to search for a large list of strings in a mysql table)

See more:

VB

MySQL

I have a large list(of string) of song titles (e.g. ~1000 titles), and I want to look them up in mysql.

I have the following code, but it gives me errors and I don't know why:

Dim test As String = "alpha - bravo#charlie - delta#echo - foxtrot"  '<<test string!!not the actual list
Query = "select song FROM songs WHERE song IN ('.implode(','," & test & ").')"
command=New mysqlcommand(query,mysqlconn)
reader="COMMAND.ExecuteReader

What I have tried:

I tried different approaches but hopefully someone spots the error.