Write a MySQL query to get the student id, email id (discard the last three characters)

Topics

Introduction

Write a MySQL query to get the student id, email id (discard the last three characters). I have used phpMyAdmin for the following Exercises.

StudentId	FirstName	LastName	Admission_fee	Admission_date	Branch	Branch_ID	Email
1	John	Smith	1000	2018-06-10	Computer Engineering	111	John
2	David	Jones	1200	2018-06-20	Civil Engineering	222	david
3	Michael	Johnson	900	2018-08-15	Chemical Engineering	333	Michael
4	Chris	Lee	1500	2018-07-10	Electrical Engineering	111	Chris
5	Mike	Brown	1600	2018-09-10	Mechanical Engineering	555	Mike
6	Lisa	Smith	1800	2018-07-10	Computer Engineering	666	Lisa
7	Mary	Smith	1600	2018-06-11	Computer Engineering	111	Mary

SELECT studentid, REVERSE( SUBSTR( REVERSE( email ) , 4 ) ) AS Email_ID
FROM students