How to get the length of a string in a column mysql
Related FAQs
- how to find which tables use innodb in mysql
- How to search a tablename in schema
- How to get the students who are in more than one group mysql
- How to find the duplicate rows by comparing two columns in a table mysql
- How to get the length of a string in a column mysql
- How to get the records posted in this month in mysql
- how to find duplicate rows in a table based on specific column
- how to determine constant values in mysql
- how to concatenate all rows of a particular column in a table mysql
- How to connect the mysql from command prompt
using length([column name])
Fri, 09/03/2010 - 13:40 — Anonymoususing length([column name]) , we can get the length of string
eg: get the students whose description length is more than 50
SELECT * from students where length(description)>50