MySQL Forums
Forum List  »  Quality Assurance

How to insert a word in front of all row fields in a specific table column
Posted by: kefi kefila
Date: June 12, 2012 01:34PM

Hello,

Is there a method that I can insert one word in front of all the values in one specific column which has thousands of records, because I don't want to do it manually.

For example I have a table with column on of it's columns called "column5".
The table has 2000 records.
I want to add the word "something " in front of all of the value in all records in this specific "column5".

Let's say the firs row of the table has the value "car" in column5.
I want this value to be changed to "something car". And so on for all the 2000 rows. The same word "something " to get in front of all the values in the column5.

Thanks :)

Options: ReplyQuote


Subject
Views
Written By
Posted
How to insert a word in front of all row fields in a specific table column
3174
June 12, 2012 01:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.