AAC SQLITE How do I remove the [VIP] prefix from my database?

[Silver ROOM]

SQLITE How do I remove the [VIP] prefix from my database?
Example: [VIP] Dawnton

 

[Rolledstone]

UPDATE players SET name = REPLACE(name, '[VIP] ', '')WHERE name LIKE '[VIP] %';

 

[Silver ROOM]

[16:54:41] Error while executing SQL query on database 'Sam': UNIQUE constraint failed: players.name, players.deleted

 

[Rolledstone]

[16:54:41] Error while executing SQL query on database 'Sam': UNIQUE constraint failed: players.name, players.deleted

¯\(ツ)/¯
id have to see it myself to work it out hard to work with something you can not see.

 

[Silver ROOM]

ok thanks...

 

[Rolledstone]

ok thanks...

you could use chatgpt to guide you in this endeavour just make sure to backup your database
sqlite doesnt support dropping constraints so you might have to find workaround such as copying the data into a different table removing it then renaming it or something.

 

[Marko999x]

you could use chatgpt to guide you in this endeavour just make sure to backup your database
sqlite doesnt support dropping constraints so you might have to find workaround such as copying the data into a different table removing it then renaming it or something.

hi santa

 

[Rolledstone]

hi santa

hi marko?