MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1 (id int, field int)
INSERT INTO table1 VALUES (1,1),(7,7) , (10,10)
select id, field from table1 where id - 9;

id
field

1
1

7
7

10
10

select id, field from table1 where 1;

id
field

1
1

7
7

10
10

select id, field from table1 where 0;