Mysql update case when

Summary: in this tutorial, you will learn how to use the MySQL expression to add if-else logic to queries.

Introduction to MySQL CASE expression

MySQL expression is a control flow structure that allows you to add if-else logic to a query.

Generally speaking, you can use the expression anywhere that allows a valid expression e.g., , and clauses.

The expression has two forms: simple and searched .

Note that MySQL has a statement that you can use only in stored programs such as stored procedures, stored functions, events, and triggers, which is not the expression covered in this tutorial.

Simple CASE expression

The following illustrates the syntax of a simple  expression:

In this syntax, matches the value with the , , etc., for equality and return the corresponding , ,… If the does not equal to any , , … returns the result in the clause if the clause is specified.

The compares the with in the clauses for equality, you cannot use it with because returns false.

Searched CASE expression

The following shows

how to use case in mysql stored procedure

update using case statement in mysql