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.
Haluk YAMANER
Founder @ Future Software UAE
Founder @ Future Linux
Click here for more about me »