Returns the position of the first occurrence of a substring.
Syntax
INSTR(str, substr)Example
Enter values below to update the example in real time.
email→at_pos→users→-- '@' 위치로 도메인 시작점 확인
SELECT email, INSTR(email, '@') AS at_pos
FROM users;