A tale of strip-typecasting in MySQL

As much as we think we know MySQL, it never fails to surprise us with unusual and weird, yet well-documented, scenarios. I was perplexed when I learnt about one such thing about MySQL today where it strip-typecasts (as I like to say it) strings to i...