help with mysql query

Vince
Spam Machine

Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0

19.02.2012, 12:34

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.

Find

« Next Oldest | Next Newest »

Messages In This Thread

Re: help with mysql query - by Vince - 19.02.2012, 12:34

Forum Jump:

Users browsing this thread: 1 Guest(s)