variable where clause

[Björn Olsson]

Is it possible to write stored procedures where you pass the where clause as a parameter, because I would like to sometimes only compare one field other times several fields. The following always gives 0 in result whatever I have in my where clause:

string strCmd = "CREATE PROCEDURE MyProcedure (query VarChar(255)) " +
"BEGIN " +
"SELECT IFNULL(Count(id),0) " +
"FROM MyTable " +
"WHERE query; " +
"END";
MySqlCommand command = new MySqlCommand(strCmd, connection);
command.ExecuteNonQuery();

I call my sp from the method

public static DataTable GetCount(string query)
{
MySqlCommand comm = new MySqlCommand();
comm.Connection = connection;
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = "MyProcedure";
comm.Parameters.Add("@query", MySqlDbType.VarChar).Value = query;
command.Connection.Open();
MySqlDataReader reader = command.ExecuteReader();
table = new DataTable();
table.Load(reader);
reader.Close();
return table;
}

And my input string 'query' can be like

FirstName = 'Bill'

or longer when needed like

FirstName = 'Bill' AND LastName = 'Smith' AND City = 'Los Angeles'