Question

How to use SQL MID() and SUBSTRING() functions in MySQL

Answer 1

-- SELECT MID(column, start, [length]) AS title FROM table_name

SELECT MID(FirstName, 1, 2) AS FirstName_Part
FROM workers

 

70+ SQL courses for beginners and professionals

Answer 2

SELECT MID(FirstName, 3) AS FirstName_Part
FROM workers

 

70+ SQL courses for beginners and professionals

Answer 3

SELECT SUBSTRING(FirstName, 3) AS FirstName_Part
FROM workers

 

70+ SQL courses for beginners and professionals

Answer 4

SELECT SUBSTRING(FirstName, 1, 2) AS FirstName_Part
FROM workers

 

70+ SQL courses for beginners and professionals