title: How to update column values depending on another column's values with CASE WHEN in SQL
body: <p>I have a MySQL database table called <code>groovers</code>, in this table I have a <code>gender</code> column and <code>profileImage</code> column, I want to change all the values of the column <code>profileImage</code> depending on what the <code>gender</code> value is where
  if <code>gender</code>='Male' then <code>profileImage</code>='imgM'
  if <code>gender</code>='Female' then <code>profileImage</code>='imgF'
  if 'Unspecified' then <code>profileImage</code>='default'
  I have a row with a Male gender and another row with Female gender, when I execute the code, the <code>profileImage</code> doesn't change.
  Here's my SQL code:</p>
  
  <pre><code>SELECT gender, profileImage,
      CASE
          WHEN gender ='Male'
          THEN profileImage = 'imgM'
  
          WHEN gender = 'Female'
          THEN profileImage = 'imgF'
  
          ELSE profileImage = 'default'
  
          END
  FROM
      groovers
  </code></pre>
  
  <p>here's my table's </p>
  
  <pre><code>CREATE TABLE groovers
  (
      user_id         INT AUTO_INCREMENT PRIMARY KEY,
      username        VARCHAR(40)                                                  NOT NULL,
      firstName       VARCHAR(40)                                                  NOT NULL,
      lastName        VARCHAR(40)                                                  NOT NULL,
      gender          enum ('Male', 'Female', 'Unspecified') default 'Unspecified' NOT NULL,
      email           VARCHAR(255)                                                 NOT NULL,
      password        VARCHAR(32)                                                  NOT NULL,
      profileImage    VARCHAR(255)                                                 NOT NULL,
  );
  </code></pre>