Anybody know this??

update `item_template` set `stat_value1`=`stat_value1` * 1.5 WHERE `stat_type1` = 3 AND 'Material' = 8;

why it doesn't work??

when i type this, "Query OK, 0 rows affected"

i know there is some items should change, but it's not

i want change stat of item

It probably means there are no results for `stat_type1` = 3 AND 'Material' = 8;
Do you get any result with
SELECT * FROM `item_template` WHERE`stat_type1` = 3 AND 'Material' = 8;