MariaDB Case expression
02:08 02 May 2022

I have the following SQL-Code in a Mariadb-Database: (1)

select Labornummer, Matrix, FaktorGW, FaktorAW
from gc_Faktoren

I need the following result:

If Matrix='AW' => I need the field "FaktorAW"

else => I need the field "FaktorGW"

Is it possible to formulate Statement (1) with a "case expression"?

sql mariadb case