I am working on using a table-wide Replace action to replace anywhere that has 2019 with 2020
The data in the column is >300 characters long, I’ve noticed that it will not let me say “Where it’s” entire cell or part of a longer text
Can I assume there is a limit in place for that type of action?
Here is a snippet of the data
SELECT count(DISTINCT customerview_totaltrunk_temp.email) AS "1/1/2019" FROM customerview_totaltrunk_temp WHERE ((customerview_totaltrunk_temp.ordercompleted >= '2018-01-01 00:00:00'::timestamp without time zone) AND (customerview_totaltrunk_temp.ordercompleted < '2019-02-01 00:00:00'::timestamp without time zone));