79761989

Date: 2025-09-11 13:39:46
Score: 1.5
Natty:
Report link

Just use the MOD function with specifying 1 then after it the number of zeros upon which the number of digits you want , for example :

UPDATE Doctors

SET id = MOD(id,10); // here I got the last digit as the number of zeros is one

SET id = MOD(id,100);// here I got the last 2 digits as the number of zeros is two

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: Mohamed Salah