5
SQL LEN function in MySQL
source link: https://fann.im/blog/2010/09/08/sql-len-function-in-mysql/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
SQL LEN function in MySQL
Sep 8, 2010
SQL: The LEN() function returns the length of the value in a text field.
SELECT LEN(column_name) FROM table_name
BUT: in MySQL LEN() does NOT work,it’s called LENGTH().
SELECT * FROM table_name WHERE LENGTH(column_name) < 5
Was this page helpful?
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK