update list set reserve_type=(case reserve_type when 2 then 5 when 3 then 4 end ) where id=1;
tp代码:
$edit_param['reserve_type'] = "(case reserve_type when 2 then 5 when 3 then 4 end )";
M('list')->where(array('id'=1))->setField($edit_param);
打印tp 执行的sql语句实际是:
UPDATE `list` SET `reserve_type`=0 WHERE ( `id`=1 )
如何让tp执行上面需要的语句呢?
最佳答案