Fetch first 5 characters of the string

Question

Hi!!

Can someone tell me how to fetch the first 5 characters of the string?

Answer 1

There are a lot of ways to fetch characters from a string. For example:

Select SUBSTRING(StudentName,1,5) as studentname from student

Answer 2

Select StudentID, StudentName, Class, Division from Student

order by StudentName asc

limit 5;