I want to edit in 'videos' table, if 'category' column has the value set to 'Music' then replace it with the value '1'.
How can i do this?
-
You need to provide more information.. what is the table definition? it seems like you're confusing rows with columns, and which value do you want replaced?Fosco– Fosco2011-06-09 19:07:53 +00:00Commented Jun 9, 2011 at 19:07
-
yes, i confused rows with columns. my bad.m3tsys– m3tsys2011-06-09 19:14:32 +00:00Commented Jun 9, 2011 at 19:14
Add a comment
|
6 Answers
I'm a bit confused as to what you're trying to accomplish. Is 'category' a column that is currently set to 'Music' for some row, and you want to set that to 1? If so:
update videos set category = 1 where category = 'Music'
answered Jun 9, 2011 at 19:08
Christopher Armstrong
7,9812 gold badges28 silver badges28 bronze badges
1 Comment
m3tsys
yes, this was what i want to say. 'category' is a column, sorry thank you, it worked.
UPDATE videos
SET category = '1'
WHERE category = 'Music'
Comments
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
answered Jun 9, 2011 at 19:08
Anirudh Ramanathan
46.8k24 gold badges137 silver badges195 bronze badges
Comments
err
update videos set category="1" where category="Music"
Take a look at the mysql docs, they are really good with explanations and examples.
Comments
You want to replace the category with '1'?
update videos
set
category = '1'
where
category = 'Music'
Comments
Most probably the category your are referring to is a column, and not a row. If that is true then this solution is apt:
UPDATE videos SET category = '1' WHERE category = 'Music'
Go through the following link which contains tutorials, fruitful for beginners: http://msdn.microsoft.com/en-us/library/bb264565%28v=sql.90%29.aspx
With regards,
Jayesh
