CPrompt^ on Nostr: Greetings! I need some assistance on #SQL. I have a table that, one of the fields are ...
Greetings! I need some assistance on #SQL. I have a table that, one of the fields are employee ID'S. However, when they were entered, they were encoded. I have a #Javascript function that converts as I need it but looking for a #sql script that will alter the entire table for me.
Here is the #javascript :
https://paste.centos.org/view/2810aab0Basically the numbers have a preceeding "3" before the number I need. So 31323334 should be 1234.
Hope that makes sense!
Published at
2023-08-18 13:46:38Event JSON
{
"id": "cd709f253a24618c3f0baaee7a655448c354ddf8862baa151dd9aeec9324446f",
"pubkey": "ce344d35f5cc619df9681fb6a5bb19a0ad5d152a381bd0fe46f89108d4f34aa4",
"created_at": 1692366398,
"kind": 1,
"tags": [
[
"t",
"sql"
],
[
"t",
"javascript"
],
[
"proxy",
"https://jazztodon.com/users/cprompt/statuses/110910924320863682",
"activitypub"
]
],
"content": "Greetings! I need some assistance on #SQL. I have a table that, one of the fields are employee ID'S. However, when they were entered, they were encoded. I have a #Javascript function that converts as I need it but looking for a #sql script that will alter the entire table for me.\n\nHere is the #javascript : https://paste.centos.org/view/2810aab0\n\nBasically the numbers have a preceeding \"3\" before the number I need. So 31323334 should be 1234.\n\nHope that makes sense!",
"sig": "961542cba919de6d87e84ea86bc7cf0c64cd022682df9ab0590db5912feede96553faccf28b4b45967b3b910600d8df715a3dca6ac55d66755bbb4de569d5bc0"
}
