.NET MVC mysql 模糊查询

-- 普通查询
string sql = "SELECT
    goods_name
FROM
    goods
WHERE
    goods_name =@goods_name ";

-- 模糊查询
string sql = @"SELECT
    goods_name
FROM
    goods
WHERE
    goods_name 
LIKE '%' +@goods_name + '%'";