update query
I am trying to update one field in a table with another parsed field from the same table.
I get the following error message.
Fatal error: Uncaught Error: Call to undefined function CONCAT() in /home/w72w9xoqmrbx/public_html/porc/OldBallots.php:14 Stack trace: #0 {main} thrown in /home/w72w9xoqmrbx/public_html/porc/OldBallots.php on line 14
I am sure I have the syntax wrong.
See attached file at line 14.
I also want to add a filter that only updates records where the documentation field is not empty.