Updating Multiple Values in the Same Column
<p>I have a data table called Movie_Stars. I want to update multiple values, but they are all in the same column. Here's what I have:</p>

<pre><code>update movie_stars
set movie_category = 'Family'
where movie_category = 'Drama'
and set movie_category = 'Children'
where movie_category = 'Cartoon'
and set movie_category = 'Teen'
where movie_category = 'Action';
</code></pre>

<p>But this generates the error "invalid user.table.column, table.column, or column specification". So what is the right column specification?</p>