Hello,
OK. If I understood the problem correctly: Can you just replace all the wrong ticker symbols in the db with the right one?
Hopefully you are doing these experiments on a dev/integration server and not production. Simply delete all transactions and addresses for these two ticker symbols and start again.
If you are in a production environment, keep a backup of the entire DB state.
Then, substitute all symbol columns in the addresses table and transactions tables. I guess that something like the following should work:
UPDATE wp_wallets_txs SET symbol='NEW' WHERE symbol='OLD';
UPDATE wp_wallets_adds SET symbol='NEW' WHERE symbol='OLD';
Hopefully you won’t get too many collisions on the unique constraints.
Let me know if this helps. If not, restore your backup and we’ll try something else.
with regards
P.S. I have moved your query to a new thread as it is unrelated to the previous thread.