MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


10.6.4-MariaDB


-- borrowed from https://stackoverflow.com/q/7745609/808921

CREATE TABLE IF NOT EXISTS `docs` (
  `id` int(6) unsigned NOT NULL,
  `time` time NOT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT INTO `docs` (`id`, `time`) VALUES
  ('1', '00:00:00'),
  ('2', '00:00:00');
SELECT
  `id`,
  `time`
FROM
  `docs`
WHERE
  `time` = 0


id
time


1
00:00:00

2
00:00:00


SELECT
  `id`,
  `time`
FROM
  `docs`
WHERE
  `time` = '0'


id
time


1
00:00:00

2
00:00:00


SELECT
  `id`,
  `time`
FROM
  `docs`
WHERE
  `time` = '0:00'


id
time


1
00:00:00

2
00:00:00


SELECT
  `id`,
  `time`
FROM
  `docs`
WHERE
  `time` = '00:00'


id
time


1
00:00:00

2
00:00:00


SELECT
  `id`,
  `time`
FROM
  `docs`
WHERE
  `time` = '0:00:00'


id
time


1
00:00:00

2
00:00:00


SELECT
  `id`,
  `time`
FROM
  `docs`
WHERE
  `time` = '00:00:00'


id
time


1
00:00:00

2
00:00:00