How do I create a search after spacing first word another text matching on row? Like <b>button <u>plastic</u> 15MM 4<u>hole</u></b>

i want to performing this query using C#

below is work your given code
Select ItemName from Item where ItemName like '%plastic%hole%'

also

Select ItemName from Item where ItemName like '%plastic%' and ItemName like '%hole%' and ItemName like '%15mm%'

this query is work
Select ItemName from Item where ItemName like '%plastic%hole%'

using this code

// string text = "Button Plastic 15MM 4Hole";
string text = "Plastic Hole";
string[] keys = text.Trim().Split(' ');

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=karthik_test;Integrated Security=True");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
string query = "", likePattern = "";

for (int i = 0; i < keys.Length; i++)
likePattern += string.Format("%{0}", keys[i]);
likePattern = likePattern.Trim() + "%";

query = likePattern.Length > 0 ? "select * from TableKeywordSearch where keywordcolumn like @keyword " : "select * from TableKeywordSearch";

cmd.CommandText = query;
cmd.Parameters.Add("@keyword", likePattern);

SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtResults = new DataTable ();
try
{
da.Fill(dtResults);
}
catch (Exception)
{

throw;
}

but not work this query
Select ItemName from Item where ItemName like '%plastic%' and ItemName like '%hole%' and ItemName like '%15mm%'