MySQLでIN句を使う

MySQL

Last updated at 2024-07-22Posted at 2024-04-11

概要

SETで変数を指定してINで条件を絞り込みたい場合は、FIND_IN_SETを使うと良い。

SET @customers = '010687,009841,010469,007352,007353,007354,008654,009484,012255';

SELECT * FROM M_CUSTOMER
WHERE FIND_IN_SET(CUSTOMER_CODE, @customers)

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up