sql数据库某字段包含某值

mssql:

SELECT * FROM tablename WHERE CHARINDEX('10', power) <> 0

mysql:

SELECT * FROM tablename WHERE locate('10', power) <> 0

注：tablename：表名 ;'10':包含的值; power：字段