SQLite Forum

I did not know that the value could not be different. Good to know.

It does not work.

The definition of the table is:
    CREATE TABLE "selectRandom" (
	`selectRandomID`    INTEGER PRIMARY KEY AUTOINCREMENT,
	`description`	    TEXT NOT NULL UNIQUE,
	`comment`	    TEXT,
	`lastUsed`	    TEXT,
        `lastUsedIdx`       INTEGER,
        `stockTypeID`       INTEGER,
        `locationID`        INTEGER,

	FOREIGN KEY(`stockTypeID`) REFERENCES `stockTypes`(`stockTypeID`),
	FOREIGN KEY(`locationID`) REFERENCES `locations`(`locationID`)
)

When I execute (in DB Browser For SQLite):
    UPDATE selectRandom
    SET    lastUsed = now, 
           lastUsedIdx = (
        SELECT MAX(MAX(lastUsedIdx), 0) + 1
        FROM   selectRandom
        WHERE  lastUsed == now
    ) 
    FROM (
        SELECT DATE('now', 'localtime') as now
    ) 
    where description == 'White Tea'

I get:
near "FROM": syntax error: UPDATE selectRandom
    SET    lastUsed = now,
           lastUsedIdx = (
        SELECT MAX(MAX(lastUsedIdx), 0) + 1
        FROM   selectRandom
        WHERE  lastUsed == now
    )
    FROM