mysql - 我怎样才能使我的 where 语句在这里工作？

Question

我有这个更新查询，当我的 where 有 2 个条件时它可以工作，但是当我再添加 3 个时它不起作用。任何人都可以看看它并告诉我出了什么问题。谢谢。

这是我的查询:

$sSQLupdate = "UPDATE settings, holidaytype SET 
settings.companyName = '$companyname', 
settings.companyAddress = '$companyaddress', 
settings.companyContact = '$companycontact', 
settings.excessot1 = '$excessot1', 
settings.multiplierOT1 = '$multiplier1', 
settings.excessot2 = '$excessot2', 
settings.multiplierOT2 = '$multiplier2', 
settings.ndRangeFrom = '$ND_in',
settings.ndRangeTo = '$ND_out',
settings.multiplierNd = '$NDmul',
holidaytype.multiplier = '$regularmul',      *(mustbe in holidaytype.id = '1')
holidaytype.multiplier = '$specialmul',      *(mustbe in holidaytype.id = '2')
holidaytype.multiplier = '$doubleregmulmul', *(mustbe in holidaytype.id = '3')
holidaytype.multiplier = '$doublespecmul'    *(mustbe in holidaytype.id = '4')

WHERE settings.id = 1 AND holidaytype.id = '1' AND holidaytype.id = '2' AND holidaytype.id = '3' AND holidaytype.id = '4'"; 

Answer 1

试试这个:

WHERE settings.id = 1 AND holidaytype.id IN ('1','2','3','4')

要根据 holidaytype.id 条件更新 holidaytype.multiplier 我建议使用 CASE 语句或单独查询。