пятница, 22 января 2010 г.

mysql

UPDATE translations SET content = REPLACE(content, '12/2009', '01/2010') WHERE `content` LIKE '%12/2009%';
UPDATE translations SET content = REPLACE(content, '11/2009', '01/2010') WHERE `content` LIKE '%11/2009%';
UPDATE translations SET content = REPLACE(content, '10/2009', '01/2010') WHERE `content` LIKE '%10/2009%';
UPDATE translations SET content = REPLACE(content, '09/2009', '01/2010') WHERE `content` LIKE '%09/2009%';
UPDATE translations SET content = REPLACE(content, '08/2009', '01/2010') WHERE `content` LIKE '%08/2009%';
UPDATE translations SET content = REPLACE(content, '07/2009', '01/2010') WHERE `content` LIKE '%07/2009%';
UPDATE translations SET content = REPLACE(content, '06/2009', '01/2010') WHERE `content` LIKE '%06/2009%';
UPDATE translations SET content = REPLACE(content, '05/2009', '01/2010') WHERE `content` LIKE '%05/2009%';
UPDATE translations SET content = REPLACE(content, '04/2009', '01/2010') WHERE `content` LIKE '%04/2009%';
UPDATE translations SET content = REPLACE(content, '03/2009', '01/2010') WHERE `content` LIKE '%03/2009%';
UPDATE translations SET content = REPLACE(content, '02/2009', '01/2010') WHERE `content` LIKE '%02/2009%';
UPDATE translations SET content = REPLACE(content, '01/2009', '01/2010') WHERE `content` LIKE '%01/2009%';


DELETE FROM test WHERE test.content LIKE '%font-size: 12px%'

SELECT DISTINCT id FROM table;

Комментариев нет: