[SOLVED] Global database update

[Shamrox]

I need to update a field in my database. I need to add the % sign to the end of numbers that currently exist in a table. Unsure how to add this to the end of the numbers for every number that exists. Can someone help me here?

[Shamrox]

Search long enough you can resolve yourself...

 

Just incase anyone else was wondering, I used this method.

 

UPDATE `table` SET `fieldname` = CONCAT(`fieldname`, 'newtext');

[fenway]

I need to add the % sign to the end of numbers that currently exist in a table.

I hightly doubt you need to do this -- you're now corrupt both the underlying value as well as the data type (it can't be numeric anymore).  BAD IDEA.  You can always format your number for output either in mysql or in php -- but don't corrupt the data!!!!