SQL WHERE id is odd?

Question

I was wondering if it were possible to list all of the ODD ID' using PHP and SQL.

I am currently using, which shows all results:

$result = $con->query("SELECT * FROM Users");

How would it be possible to list only ODD results using PHP and SQL?

thanks in advance..

Answer 1

Or you can do probably faster solution:

$result = $con->query("SELECT * FROM Users WHERE id % 2");

DEMO