MySQL Operators(オペレータ)

ひかくオペレータ
比較オペレータがTRUE(1)とFALSE(0)またはNULL = > < >= <= <> !=を返すこれらは、定数比較だけでなく行比較にも使用できる
Name
Description
BETWEEN … AND … expr BETWEEN min AND max=(min <= expr AND expr <= max)、非を取るには前面にNOTを加えればよいCOALESCE(value,...)
最初のNULL以外の値を返し、すべてNULLの場合NULLを返します.
=
Equal operator
<=>
NULL-safe equal to operator
>
Greater than operator
>=
Greater than or equal operator GREATEST(value1,value2,...)
最大値を返すN (value,...) SELECT 2 IN (0,3,5,7)-> 0、また、inはwhere後の選択範囲に用いられる
INTERVAL()
Return the index of the argument that is less than the first argument
IS
Test a value against a boolean
IS NOT
Test a value against a boolean
IS NOT NULL
NOT NULL value test
IS NULL
NULL value test
ISNULL()
Test whether the argument is NULL LEAST(value1,value2,...)
最小パラメータを返します
<
Less than operator
<=
Less than or equal operator
LIKE
Simple pattern matching
NOT BETWEEN … AND …
Whether a value is not within a range of values
!=, <>
Not equal operator
NOT IN()
Whether a value is not within a set of values
NOT LIKE
Negation of simple pattern matching
STRCMP()
Compare two strings
=番号オペレータ:mysqlで文字列フォーマットが自動的に数値フォーマットに変換されます

mysql> SELECT 1 = 0;
        -> 0
mysql> SELECT '0' = 0;
        -> 1
mysql> SELECT '0.0' = 0;
        -> 1
mysql> SELECT '0.01' = 0;
        -> 0
mysql> SELECT '.01' = 0.01;
        -> 1

IS boolean_value

mysql> SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;
        -> 1, 1, 1

IS NOT boolean_value

mysql> SELECT 1 IS NOT UNKNOWN, 0 IS NOT UNKNOWN, NULL IS NOT UNKNOWN;
        -> 1, 1, 0

IS NULL

mysql> SELECT 1 IS NULL, 0 IS NULL, NULL IS NULL;
        -> 0, 0, 1

IS NOT NULL

mysql> SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL IS NOT NULL;
        -> 1, 1, 0

論理演算子
Name
Description
AND, &&
Logical AND
NOT, !
Negates value
OR,
XOR
Logical XOR
リファレンス
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html