I have a MySQL table that has 3 fields (for simple example)...
name, place, and video.
How do I make a change to every record where place="dvd"
On these records I want to change place from "dvd" to " " (blank)
and also on those records where place="dvd" I want to change video to = "A"
How does that command look?
I am using phpMyAdmin by the way.
Thanks.
name, place, and video.
How do I make a change to every record where place="dvd"
On these records I want to change place from "dvd" to " " (blank)
and also on those records where place="dvd" I want to change video to = "A"
How does that command look?
I am using phpMyAdmin by the way.
Thanks.