TO change a single row filed to 1 and all other to zero codeigniter

Question

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

can any one please provide the codeigniter equivalent of this above code

UPDATE table SET 'status_field'=IF(id=4, 1, 0)

the code will toggle all values of status_field to 0 and for the the specified row (with id=4) sets the status_field to 1

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

140 views

1 Answer

深蓝 · Answer 1 · 2021-01-27T03:50:32+0000

answered Jan 27, 2021 by 深蓝 (71.8m points)

等待大神答复

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…