SQLite UPDATE multiple rows in a column with a single value except one row (something like invert selection) : flutter

Question

I have a list of objects that only one of them can be selected. For this I have a column in this table (table of objects) that shows the status of the object (selected or not selected) I want to select the item to be clicked and change the status to the selected mode and uncheck the other items.

what is the solution in sqlite/sqflite flutter?

Something like `update yourtable set status=0 where id <> ?` — Shawn, Apr 06 '21 at 07:33
`<>` is not equals in SQL... Want a better answer, you're going to have to give more information like the schema of your table. — Shawn, Apr 06 '21 at 08:01

score 0 · Answer 1 · answered Apr 06 '21 at 08:32

0

I don't know Flutter. A conditional update in SQL can look like this:

update mytable set selected = case when id = 123 then 1 else 0 end;

answered Apr 06 '21 at 08:32

Thorsten Kettner

89,309
7
49
73

SQLite UPDATE multiple rows in a column with a single value except one row (something like invert selection) : flutter

1 Answers1