order in table sqlite # code example
Example 1: mysql is in list
SELECT
column1,column2,...
FROM
table_name
WHERE
(expr|column_1) IN ('value1','value2',...);
Example 2: how to subtract from the value of a table in sql
UPDATE Inventory
SET Quantity = Quantity - 1
WHERE InventoryID = 2