Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Date_of_Registration, Student_ID, Surname, Other_Names, Full_Name,Date_of_birth, IF(
- Class = 'Class 1' and DATE_ADD(NOW(), INTERVAL 1 YEAR), 'Class 2',
- IF(Class = 'Class 2' and DATE_ADD(NOW(), INTERVAL 1 YEAR), 'Class 3',
- IF(Class = 'Class 3' and DATE_ADD(NOW(), INTERVAL 1 YEAR), 'Class 4',
- IF(Class = 'Class 4' and DATE_ADD(NOW(), INTERVAL 1 YEAR), 'Class 5',
- IF(Class = 'Class 5' and DATE_ADD(NOW(), INTERVAL 1 YEAR), 'Class 6',
- IF(Class = 'Class 6' and DATE_ADD(NOW(), INTERVAL 1 YEAR), 'JHS 1',
- IF(Class = 'JHS 1' and DATE_ADD(NOW(), INTERVAL 1 YEAR), 'JHS 2',
- IF(Class = 'JHS 2' and DATE_ADD(NOW(), INTERVAL 1 YEAR), 'JHS 3',
- IF(Class = 'JHS 3' and DATE_ADD(NOW(), INTERVAL 1 YEAR), 'Completed', Class))))))))) AS Class,
- Gender, Age, Address, Hometown, Father_Name, Father_Contact, Mother_Name, Mother_Contact FROM student_info
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement