I've been trying to figure this out for two days now and would really appreciate some help. I've imported data from a csv where one field contained html data encoded in base64.
The idea is to loop over every row and run FROM_BASE64 on it.
How do I structure a query that:
- Loops over all lines
- Calls FROM_BASE64 for each line
- Runs UPDATE (or similar functionality) on that same row and column
I'm running MariaDB (MySQL equivalent).