尝试这个:
SELECT LOWER(CONCAT_Ws(title,description)) AS concatenated WHERe concatenated LIKE '%searchterm%'
或(让您看到差异)
SELECT LOWER(CONCAT_Ws(title,description)) AS concatenated WHERe concatenated LIKE LOWER('%SearchTerm%')
尝试这个:
SELECT LOWER(CONCAT_Ws(title,description)) AS concatenated WHERe concatenated LIKE '%searchterm%'
或(让您看到差异)
SELECT LOWER(CONCAT_Ws(title,description)) AS concatenated WHERe concatenated LIKE LOWER('%SearchTerm%')