Why does WHERE `d` = 0 select the row with value 'code: 404'?

Question

SQL

`d` tinytext COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
I'm writing a query: a string with a value of 'code: 404' is selected, so it is not selected: Why?
SELECT * FROM `table` WHERE `d` = 0
SELECT * FROM `table` WHERE `d` = '0'

Answer 1

Because there is no need to compare strings and numbers at all. If the field is string - compare only with the string. Though thus there is also well documented behavior .