function xxx in MySQL. LEN does not exist error

Today in MySQL want to use a self-contained function to detect the length of the field content as

The code is as follows	Copy Code
Select ID from BB where len (field) >5

Results appear

FUNCTION xxx. LEN does not exist

Verified that there is no Len this function in MySQL, then the test field length is that?

The code is as follows	Copy Code
Select ID from BB where LENGTH (field) >5

Run results

Okay, OK.

And then I checked the length usage.

SQL LENGTH () syntax

The code is as follows	Copy Code
SELECT LENGTH (column_name) from table_name SELECT * from Broker_info where LENGTH (avatar) =11

Summarize

This is the use of MSSQL and MySQL when taken for granted in MySQL also has Len function, Len function seems to have only the MSSQL OH.

For more details please see: http://www.111cn.net/database/mysql/38578.htm