A50
A50
DTDrizzle Team
Created by A50 on 1/4/2024 in #help
Update a field only if currently null
I have a users table with a field called mainListId which is null by default. whenever a user creates a new list, I need to check if *mainListId *is null, and if so, I update this field to contain the new list id. Is it somehow posibble to update *mainListId * only if it's currently null, so that I won't have to make another query just to check if it's currently null or not?
8 replies