Returns the position of a regular expression match.
Syntax
REGEXP_INSTR(str, pat [, ...])Example
Enter values below to update the example in real time.
phone→last4_pos→contacts→SELECT REGEXP_INSTR(phone, 'd{4}$') AS last4_pos
FROM contacts;
Returns the position of a regular expression match.
REGEXP_INSTR(str, pat [, ...])Enter values below to update the example in real time.
phone→last4_pos→contacts→SELECT REGEXP_INSTR(phone, 'd{4}$') AS last4_pos
FROM contacts;