FUNCTIONxxx. LENdoesnotexist error in mysql

For more information about the FUNCTIONxxx. LENdoesnotexist error in mysql, see.

In mysql, if the FUNCTION xxx. LEN does not exist error is required, refer to it.

In mysql today, I want to use a built-in function to check the content length of a field, as shown in

The Code is as follows:
Select id from bb where len (field)> 5

Result

FUNCTION xxx. LEN does not exist

It turns out that there is no LEN function in mysql, so what is the length of the test field?

The Code is as follows:
Select id from bb where LENGTH (field)> 5

Running result

OK

Later, I checked the Length usage.

SQL LENGTH () syntax

The Code is as follows:
Select length (column_name) FROM table_name Select * from broker_info where LENGTH (avatar) = 11

Summary

When mssql and mysql are used, it is assumed that there are also len functions in mysql. len functions seem to only exist in mssql.

For more details, see: