INSTR(string, searchString, [, startInt])

• string - any string.
• `searchString. - any string to search for.
• startInt - start position for the lookup.

Returns the location of a search string in a string. If a start position is used, the characters before it are ignored. If position is negative, the rightmost location is returned. 0 is returned if the search string is not found. Please note this function is case sensitive, even if the parameters are not.

Check if a string includes @ symbol:

SELECT INSTR(EMAIL,'@') FROM Players;