Search in mysql database table?

Question

PHP

There is a database with a table (id, name, mail , ip, ... ). When registering on the site, the user specifies the mail. How to send a query to the database to search (check) the existence of mail? And how to check or what will return the execution of the action if it does not find or find mail (true, false ... or something else).

Answer 1

SELECT * FROM `tablename` WHERE `mail`=$_POST['mail'];
Returns either an array of data or null.
Screen and edit yourself.

Answer 2

www.mysql.ru/docs/man/SELECT.html