Skip
Arish's avatar

108. Filtering by LENGTH

Filter Using LENGTH

sql
1SELECT * FROM students
2WHERE LENGTH(name) > 5;

Names longer than 5 characters.

Example: Short Names

sql
1SELECT name FROM students
2WHERE LENGTH(name) <= 4;