Need help with a query

**TheZaronz** · 06-29-2009

Okey, so I tried to make a query to set 'mindamage' 1 where 'mindamage' 120 and 'maxlevel' = 10

Code:

UPDATE creature_proto
SET mindamage='1 '
WHERE mindamage = '120' and maxlevel = '10';

Obviously I failed anyone know how to fix? +Rep if you can!

**Bunster** · 06-29-2009

Dam dam dam free Rep going and i dnt have a clue xD

**Reflection** · 06-29-2009

Code:

UPDATE `creature_proto` SET mindamage='1' WHERE mindamage='120' AND maxlevel = '10';

Try that, otherwise it's

Code:

UPDATE TABLE `creature_proto` SET mindamage='1' WHERE mindamage='120' AND maxlevel = '10';

Good luck.

**TheZaronz** · 06-29-2009

Thanks for fast reply, anyways update is it possible to do it to be like < 10 as anything from 10 and lower?

**Reflection** · 06-29-2009

Code:

UPDATE `creature_proto` SET mindamage='1' WHERE mindamage='120' AND maxlevel < '10';

Should do it.

**TheZaronz** · 06-29-2009

Ahh, thanks! +Rep

Edit: Just gotta spread, will +Rep after I have

User Tag List