Adding new pCategory Column

Editor
Jul 16, 2012 at 4:12 PM

I added a new pCategory column to the datebase and to the table rc_Pages. Now I need to update that table depending on the pName, 

 

so if the pName begins with C-Sharp then pCategory = C#.

 

how can I do this?

 

Coordinator
Jul 17, 2012 at 9:30 PM

Do you want to run query and update the pages that you already have in db ?

UPDATE [rc_Pages]
   SET pCategory 'C#'
 WHERE pname like 'C-Sharp%'

 

Editor
Jul 18, 2012 at 11:09 AM
Edited Aug 4, 2012 at 11:48 PM
razorc wrote:

Do you want to run query and update the pages that you already have in db ?

UPDATE [rc_Pages]
   SET pCategory 'C#'
 WHERE pname like 'C-Sharp%'

 

Ah yeah thanks.