Update multiple row with multiple where Codeigniter

Question

is it possible to update multiple row with multiple where?

    id | formid
   PK 1  | 2
   PK 2  | 2

i need to switch id 1 to 2 and 2 to 1 also need to filter with where formid = 2. is it possible ?

score 0 · Answer 1 · answered May 23 '16 at 09:13

0

You can do that...by using this query

update mytbl a
inner join mytbl b on a.formid <> b.formid
set a.id = b.id
where a.id in (1,2) and b.id in (1,2)

answered May 23 '16 at 09:13

Kunal

how about switching between id ? – Ibnu Habibie May 23 '16 at 09:17
id | formid 1 | 20 2 | 20 i want to switch the id of them . – Ibnu Habibie May 23 '16 at 09:21
that is what i have given to you as a answer...!!which may help you probably @IbnuHabibie – Kunal May 23 '16 at 09:24

score 0 · Answer 2 · edited May 23 '17 at 12:31

0

Have you tried anything that does not work?

This is a problem of switching 2 values. You can try with temporary variable as said here.

Another option in by join, as stated here.

edited May 23 '17 at 12:31

Community

answered May 23 '16 at 09:28

user2351934

2 Answers2