Split SQL Accounts from ESX Legacy

Hi,
since esx_legacy the accounts in the database are saved as a string.
The problem is that I cant sort the accounts table to find out who is a suspect because of his high amount of money.
If possible I would like to create a function or know a sql statement that I can insert everytime I want to check the accounts that the string gets splitted to the columns money, bank and black_money.
Please keep in mind that the order how the accounts are saved isnt the same for everyone.

Here is a picture where you can see the accounts column and the three created columns where I want to export the single accounts to.

Thanks for reading and I hope someone can help me and the whole esx_legacy community :slight_smile:

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.