有效地检查文本列中是否存在文本

I have a table with about 2,000,000 rows. I need to query one of the columns to retrieve the rows where a string exsists as part of the value. I have a table with about 2,000,000 rows. I nee