Returns the position of the nth occurrence of a substring.
Syntax
INSTR(str, substr [, pos [, n]])Example
Enter values below to update the example in real time.
email→at_pos→users→-- '@' 위치 조회
SELECT email, INSTR(email, '@') AS at_pos
FROM users;