I am using CFExecute to launch a batch file to interact with
another application via the command line. Within the batchfile I
would like perform some logic and one set is to Update a record in
MySQL database. Basically what I want to do is something like this
but I know this is the right syntax.

Thanks for the feeback you got me in the right direction. For
anyone that needed the final solution it was
"C:\Program Files\MySQL\MySQL Server 5.0\bin\MySQL.exe" -u
root -pt12345 -e "UPDATE candidatejobboard SET SubmissionStatus=2
WHERE JobBoardSubmissionID=39" test