SQL query to update a column with a random text value from an array of 4 values

I have a column in my table that I want to update each row with text selected randomly from an array of 4 values array = {value1, value2, value3, value4} is there a query to select one random value d=from the array then update the field ?

https://stackoverflow.com/questions/67292741/sql-query-to-update-a-column-with-a-random-text-value-from-an-array-of-4-values April 28, 2021 at 09:52AM