Question

数据库查询，有一张表，字段名：xxx，意思是，一条select语句查询出xxx中字符串长度小于10的记录

Answer 1

select * from 表名 where len(xxx)<10

Answer 2

select xxx from tablename where len(xxx)<10

Answer 3

select * from tablename where length(xxx)<10