PostgreSQL›String Functions›POSITION
←REPLACE

POSITIONString Functions

LPAD→

Returns the position of a substring.

Syntax

POSITION(substr IN str)

Example

Enter values below to update the example in real time.

email→
at_pos→
users→
-- '@' 위치 찾기
SELECT email, POSITION('@' IN email) AS at_pos
FROM users;