This website works better with Javascript
The MyWAY SQL Manager can be downloaded here for free:	as PHP installation file	as GZIP file	as ZIP archive
If the download from this page does not work, you can also download the program here (Virus checked at heise.de).
By downloading you accept the General Terms and Conditions
The program MyWAY SQL-Manager only works with Javascript

	©	SQL :: Manager
				Home	Program Information	Technical details	Free download	Donate for a cup of coffee

MySQL and MariaDB - Overview of the Comparison functions

MySQL and MariaDB provides a variety of comparison functions that can be used to compare values, perform conditional logic and filter data based on certain criteria in SQL queries. They can be combined with other MySQL functions and operators to perform more complex comparisons and data transformations.

Vergleichs-Funktionen

COALESCE	COALESCE(%, %)
	Gibt das erste Nicht-NULL-Argument zurück. More about COALESCE Function
DECODE_ORACLE	DECODE_ORACLE()
	Decodiert einen Binärstring im Oracle-Modus. More about DECODE_ORACLE Function
GREATEST	GREATEST(%, %)
	Gibt das größte Argument zurück. More about GREATEST Function
INTERVAL	INTERVAL(%, %)
	Gibt den Index des Arguments zurück, das kleiner als das erste Argument ist. More about INTERVAL Function
IF	IF(Expression, Value1, Value2)
	Wenn/sonst-Konstrukt. More about IF Function
LEAST	LEAST(%, %)
	Gibt das kleinste Argument zurück. More about LEAST Function
STRCMP	STRCMP(String 1, String 2)
	Vergleicht zwei Zeichenketten. More about STRCMP Function

Updated: 2025-11-04

2020-2025 Heino Cunze-Fischer