Select by "String Length" in MySQL
663

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 fastest way to change yourself is to hang out with people who are already the way you want to be. Reid Hoffman
Haluk YAMANER - Personal
Contact Form
You must complete Security Verification to submit your form.