Select by "String Length" in MySQL
281

For queries requiring to "select" based on "length" of a string, it's very simple usage in MySQL.

SELECT * from TABLE where length(ColumnName) < 3

For example, this query will list strings less than 3 chars.

You can use on any combinations ask you wish for longer or shorter, equal up to requirement.

If you are looking for consultation, fill the Contact Form below.
The day science begins to study non-physical phenomena, it will make more progress in one decade than in all the previous centuries of its existence. Nikola Tesla
Haluk YAMANER - Personal
Contact Form
You must complete Security Verification to submit your form.