Евгений Шевцов

select id 
from tab 
where real_time > LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 2 MONTH))
  AND real_time < DATE_ADD(LAST_DAY(CURDATE() - INTERVAL 1 MONTH), INTERVAL 1 DAY);

Ну я решил наверное не правильным и долгим но рабочим методом.
Конечный запрос получился такой

SELECT * FROM 
(SELECT `date`, COUNT(`hard`) AS `count` `, COUNT(DISTINCT`hard`) AS `uniq` FROM `statistic` GROUP BY `date`) T1,
(SELECT `date`, COUNT(`ip`) AS `ipcount`, COUNT(DISTINCT`ip`) AS `uniqip` FROM `download` GROUP BY `date`) T2
WHERE T2.date = T1.date

Сделал вот так
UPDATE `alias` SET `keyword` = REPLACE( `keyword` , '.html', '' ) WHERE `keyword` LIKE '%.html'