mysqli_query不提供电子邮件查询的结果

Question

I have a database in phpmyadmin and im trying to query the email fields from it, and it doesn't seem to work. The email field type is varchar and they contain the @ special character: [e-mail] I tried querying from the phpmyadmin console too but with no success.

Im using the following mysqli_query to get the specific fields:

ex: $email="[e-mail]"

$qres = mysqli_query($conn, "SELECT * FROM users WHERE email='".$email."'")
or die("Query error!");
$match = mysqli_num_rows($qres);
echo $match;

The $match variable returns 0 which means the query works but doesn't return any result, but my database contains multiple entries with the specific email. Im guessing that is something to do with the @ special character, but not really sure.

Answer 1

use like keyword in sql statement like this

$qres = mysqli_query($conn, "SELECT * FROM users WHERE email like '%$email%'");