[TrinityDB] Is there any way to add and additional '0' in a selected column?

[ReppzYouTube]

Hi i've been working on this for ages now and since SQL isn't my strongest language i'm having trouble. What im trying to do is for example theres a cloak with + 86 Stam i want to insert a SQL query to change all items with all stats to add a '0' after so the cloak for example would be +860 stam im not looking to update a certain value im looking to update all of them if you understand :S thanks

[stoneharry]

Make a backup of your DB in case it goes wrong, but try something like this:

UPDATE `items` SET `columnname` = * + "0";

I have no idea whether that will work. :/ The reason I used " instead of ' is to try and treat it as a string.

[Dombo]

UPDATE <items table> SET <stats column> = <stats column>*10

Try this?

EDIT: on the contrary to harry's query, I think multiplying by 10 would be the best solution.

[stoneharry]

Yup that should work Dombo. Just would only be a solution for if you wanted to add 0's, and not a solution for if you wanted to add other things (for example a 1 or a word to a name).

[ReppzYouTube]

UPDATE <items table> SET <stats column> = <stats column>*10

Try this?

EDIT: on the contrary to harry's query, I think multiplying by 10 would be the best solution.

TYVM it worked +rep for you

[lykanbluepaws]

Could you be more specific as to what column you edit? and im new to SQL and im using HeidiSQL 5.0.0.3272

[Kiev]

UPDATE <items table> SET <stats column> = <stats column>*10

<items table> would be items

<stats column> would be the stat column... logical.