POSITION when substring is absent

Question

Accepted Answer

When the search substring is not found, POSITION returns 0 - not NULL and not -1. This differs from many programming languages that return -1 for 'not found'. You can use this in a WHERE clause: WHERE POSITION('@' IN email) > 0 to find rows that contain an '@' character.