Extracts a substring from a specified position and length.
Syntax
SUBSTRING(str, start, len)Example
Enter values below to update the example in real time.
resident_no→birth_part→members→-- 주민번호 앞 6자리
SELECT SUBSTRING(resident_no, 1, 6) AS birth_part
FROM members;