MariaDB Case expression
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"?