--避免使用WHERE ... OR .... 用UNION 效率做法SELECT *
FROM TABLE
WHERE CONTAINS(列名,'你' )
union
SELECT *
FROM TABLE
WHERE CONTAINS(列名,'我' )
union SELECT *
FROM TABLE
WHERE CONTAINS(列名,'他' )
union
SELECT *
FROM TABLE
WHERE CONTAINS(列名,'哦' )
FROM TABLE
WHERE CONTAINS(列名,'你' )
union
SELECT *
FROM TABLE
WHERE CONTAINS(列名,'我' )
union SELECT *
FROM TABLE
WHERE CONTAINS(列名,'他' )
union
SELECT *
FROM TABLE
WHERE CONTAINS(列名,'哦' )
select * from table1 where field1 like %你 我 他 哦% or field2 like %你 我 他 哦%...
依此类推.