select length(字段) from table; select * from table where length(字段) > 6 ; 转载于:https://www.cnblogs.com/seveneleven/archive/2012/07/17/2595839.html