mysql Opposite of SUBSTRING_INDEX

mysql, substring

Solution

Use a negative value for `count` like this:

SELECT SUBSTRING_INDEX(email,'@',-1)

See the documentation here:

http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_substring-index

Problem

I can select the text string before the @ character: sample entry in DB: email@domain.com , sample output: email with: ``` SELECT SUBSTRING_INDEX(email,'@',1) ``` but what is the command for selecting text string after the @ character ? Thank you

Original source