Hello all, I might be missing something obvious here but I'm trying to write a query to update an enum-type field in a retool database (beta) table.
The column is called
change_status and the options are
My query looks like
update event_ops_modifications set change_status = "Success" where id = 1
I know I can successfully modify other columns that have fields like number or text successfully, but whenever I try this encounter the error
message:"column "Success" does not exist"
Is this just a thing I am unable to do or am I making a trivial mistake somewhere?
Also, please let me know if this post requires more context.