CREATE TABLE `articles` (

  `id` int(11) NOT NULL,

  `title` varchar(45) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `articles` VALUES ('1', 'Judge delays Oscar Pistorius ruling');

INSERT INTO `articles` VALUES ('2', 'Warner dedicates century to Hughes');

INSERT INTO `articles` VALUES ('3', 'Torture report: Battle lines being drawn');

SELECT `id`, SHA1(`title`) AS `column_1`

FROM `articles`

HAVING `column_1` LIKE '5%';

-- 1 row(s) returned

SELECT `id`, SHA1(`title`) AS `column_1`

FROM `articles`

HAVING UPPER(column_1) LIKE '5%';

-- 1 row(s) returned

SELECT `id`, SHA1(`title`) AS `column_1`

FROM `articles`

HAVING UPPER(`column_1`) LIKE '5%';

-- Error Code: 1054. Unknown column 'column_1' in 'having clause'