1、查询汉字及长度
SELECT *FROM [表] WHERE [列名] LIKE '%[吖-座]%' and len( [列名])>10
2、查询字母
SELECT *FROM [表] WHERE [列名] LIKE '%[a-z]%'
3、查询数字
SELECT *FROM [表] WHERE [列名] LIKE '%[0-9]%'
1、查询汉字及长度
SELECT *FROM [表] WHERE [列名] LIKE '%[吖-座]%' and len( [列名])>10
2、查询字母
SELECT *FROM [表] WHERE [列名] LIKE '%[a-z]%'
3、查询数字
SELECT *FROM [表] WHERE [列名] LIKE '%[0-9]%'