mysql如何查询字段最长的数据:
SELECT MAX(LEN(name)) FROM customers;
SELECT MAX(LENGTH(name)) FROM customers;
SELECT name FROM customers ORDER BY LENGTH(name) DESC LIMIT 1;
1、SQL Server
select
`字段`, len(`字段`)
from 表名
where
len(`字段`) = ( select max(len(`字段`)) from 表名 )
2、MySQL
select
`字段`, length(`字段`)
from 表名
where
length(`字段`) = ( select max(length(`字段`)) from 表名 )