How would you query a table where the id number is an even number?

Question

The query has to output all columns with an even id number.

Answer 1

Olwethu Shezi

Use MOD function in where clause like:

MOD(id, 2) = 0

Answer 2

Describe your table structure first. How can anyone help you without knowing the table structure?