MySQL 8.0

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

select version();

version()

8.0.30

CREATE TABLE integers(i INTEGER PRIMARY KEY NOT NULL);

INSERT INTO integers VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

Records: 10  Duplicates: 0  Warnings: 0

SELECT COUNT(*) FROm integers;

COUNT(*)

10

SELECT COUNT(i = 2) FROM integers

COUNT(i = 2)

10