SELECT * FROM movies WHERE item LIKE 'M%'

//var declair
string sql;
string[] tables = new string[2];
tables[0] = "movies";
tables[1] = "games";
tables[2] = "music";
//now we need the for loop:
for (int x=1; x<2; x++)
         //now to build the sql string
         sql = "SELECT * FROM " << tables[x] << " WHERE item LIKE 'M%'";
         //then do your select here, i would use another array to hold the results from each     select statment.


//then display the search results here.

 using System;
 using System.Data;
 using ByteFX.Data.MySqlClient;

 public class Test
 {
    public static void Main(string[] args)
    {
       string connectionString =
          "Server=SERVERNAME.com;" +
          "Database=DBNAME;" +
          "User ID=USERID;" +
          "Password=PASSWORD;";
       IDbConnection dbcon;
       dbcon = new MySqlConnection(connectionString);
       dbcon.Open();
       IDbCommand dbcmd = dbcon.CreateCommand();

       string sql =
           "SELECT firstname, lastname " +
           "FROM test";
       dbcmd.CommandText = sql;
       IDataReader reader = dbcmd.ExecuteReader();
       while(reader.Read()) {
            string FirstName = (string) reader["firstname"];
            string LastName = (string) reader["lastname"];
            Console.WriteLine("Name: " +
                  FirstName + " " + LastName);
       }
       // clean up
       reader.Close();
       reader = null;
       dbcmd.Dispose();
       dbcmd = null;
       dbcon.Close();
       dbcon = null;
    }
 }