Adding Altered content to Msql

[chazzy69]

Ok this may seem a little strange but what i Im trying to add an altered version of information already stored in my database.

Basically i have a colum that has strings of numbers and characters, now i want to have another colum with just the numbers from the other.

I have already found out how to remove unwanted characters from strings using php. I know where to add the function into my code cause i already have a cleanup function of sorts.

What i need to know is it possible do something like this, kinda of like a 2way process with msql add and retrieving at the same time.

Oh yer i wanna try and do this without downloading all listing modifying them all then putting them back up

I hope this makes sense, if it don't i can try and explain it better;

Any help is appreciated,

[Dormilich]

I've heard that you could do something like this with SQL, too. you could ask the people at the MySQL/SQL Server (...) forums, if they know how to do this.

regards

[chazzy69]

Thanks for the reply but i found an easy way to achieve this, thanks