Skip to content

Instantly share code, notes, and snippets.

@itsam
Last active October 25, 2015 12:35
Show Gist options
  • Save itsam/d46d6dc3edadec91d08b to your computer and use it in GitHub Desktop.
Save itsam/d46d6dc3edadec91d08b to your computer and use it in GitHub Desktop.
Change action to enum like values
UPDATE scsue_imc_log SET action='step'
WHERE
action = "Initial commit" OR
action = "Αρχική καταχώρηση" OR
action = "Η κατάσταση του αιτήματος μεταβλήθηκε" OR
action = "Step modified" OR
action = "Comentario Inicial" OR
action = "Hacer inicial" OR
action = "Paso modificado"
;
UPDATE scsue_imc_log SET action='category'
WHERE
action = "Category modified" OR
action = "Η κατηγορία μεταβλήθηκε" OR
action = "Categoria modificada"
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment