Adding new pCategory Column

Jul 16, 2012 at 5: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?

 

Jul 17, 2012 at 10: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%'

 

Jul 18, 2012 at 12:09 PM
Edited Aug 5, 2012 at 12:48 AM
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.