MySQL Forums
Forum List  »  Newbie

How to update all records by inserting a character
Posted by: Anees Muhammed
Date: March 09, 2009 02:46AM

I need To update all the records of my table by adding a space between two characters

For eg
id Name
1 category name -item name
2 category name -item name2
2 category name -item name3

This is how i stored the records
i want to update them all as
id Name
1 category name - item name
2 category name - item name2
2 category name - item name3
(Inserted a space between - and item name)

How can i update all records

Regards
Anees

Options: ReplyQuote


Subject
Written By
Posted
How to update all records by inserting a character
March 09, 2009 02:46AM


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.