mssql:
SELECT * FROM tablename WHERE CHARINDEX('10', power) <> 0
mysql:
SELECT * FROM tablename WHERE locate('10', power) <> 0
注:tablename:表名 ;'10':包含的值; power:字段
mssql:
SELECT * FROM tablename WHERE CHARINDEX('10', power) <> 0
mysql:
SELECT * FROM tablename WHERE locate('10', power) <> 0
注:tablename:表名 ;'10':包含的值; power:字段
转载于:https://www.cnblogs.com/finary/p/3553234.html