[Помогите!] Запрос MySQL

[zzzuro]

Всем привет. Пожалуйста помогите сделать запрос для MySQL .
Нужно:
1) Редактировать таблицу droplist
2) Чтобы была колонка chance (которую нужно резать)
3) Была колонка mobid (и чтобы я мог вписать туда айди моба)
4) И был запрет режущих айди итемов

PS. в общем я хочу порезать шанс дропа всем рб на 50% но не резать адену точки и эпик бижу

Пытался сделать не получилось =( . В MySQL слаб =(

Вот если что мой код

Цитата: UPDATE droplist SET chance = chance * 0.5 WHERE type = '25372' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25375' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25378' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25146' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25357' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25373' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25380' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25528' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25001' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25362' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25366' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25060' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); UPDATE droplist SET chance = chance * 0.5 WHERE type = '25127' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360);

И ошибка MySQL

Цитата: [Err] 1054 - Unknown column 'type' in 'where clause' [Err] UPDATE droplist SET chance = chance * 0.5 WHERE type = '25372' NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,9 915,6576,6575,6574,6573,6572,6571,6570,6569,6578,6 577,960,959,956,955,952,951,948,947,730,729,6362,6 361,6360); [Msg] Finished - Unsuccessfully --------------------------------------------------