[ajwar]

Hi, how to check if field `email` contains @ symbol?


Examlple: if john@hotmail.com contains @.

[aRoach]

For first, put the value of the E-mail in a String Variable and check it with STRCAT

[Vince]

PHP код:

SELECT `email` FROM `yourtable` WHERE `name` = 'John' AND INSTR(`email`, '@') <> 0 


Then use mysql_num_rows to check the result. If no result is returned, the email field does not contain the @ symbol.

[ajwar]

Quote:

Originally Posted by Vince PHP код: SELECT `email` FROM `yourtable` WHERE `name` = 'John' AND INSTR(`email`, '@') <> 0  Then use mysql_num_rows to check the result. If no result is returned, the email field does not contain the @ symbol.

thank's.