×
Night mode
Sign up
Login
LEFT
The function 
LEFT
returns leftmost characters. In this case 5 characters because we pass 5 as second parameter
SELECT 
    LEFT(first_name, 5) AS 'five leftmost characters'
FROM students
by Valeri Tandilashvili
4 years ago
MySQL
String functions
Full MySQL Course for Beginners
1
Pro tip: use ```triple backticks around text``` to write in code fences