By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,304 Members | 1,242 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,304 IT Pros & Developers. It's quick & easy.

Adding Altered content to Msql

100+
P: 196
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,
Oct 26 '08 #1
Share this Question
Share on Google+
2 Replies


Dormilich
Expert Mod 5K+
P: 8,639
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
Oct 26 '08 #2

100+
P: 196
Thanks for the reply but i found an easy way to achieve this, thanks
Nov 5 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.