MySQL-এ CASE স্টেটমেন্টে OR শর্ত ব্যবহার করা

MySQL-এ CASE WHEN এক্সপ্রেশনে OR অপারেটর ব্যবহার করে একাধিক শর্ত যাচাই করা যায়।

সিনট্যাক্স

SELECT column1,
       CASE WHEN condition1 OR condition2 THEN 'Message1' ELSE 'Message2' END AS Alias
FROM yourTable;

উদাহরণ: সিট কনফার্মেশন

CREATE TABLE ReservationSystems (
    Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    Name VARCHAR(20),
    isSeatConfirmed TINYINT
);

INSERT INTO ReservationSystems (Name, isSeatConfirmed) VALUES
('Larry', 0), ('Bob', 1), ('Mike', NULL),
('David', 1), ('Carol', 0), ('James', 1);

CASE WITH OR

SELECT Name,
       CASE WHEN isSeatConfirmed = 0 OR isSeatConfirmed IS NULL
            THEN 'YOUR SEAT IS NOT CONFIRMED'
            ELSE 'YOUR SEAT IS CONFIRMED'
       END AS SEATCONFIRMSTATUS
FROM ReservationSystems;

ফলাফল

+-------+----------------------------+
| Name  | SEATCONFIRMSTATUS          |
+-------+----------------------------+
| Larry | YOUR SEAT IS NOT CONFIRMED |
| Bob   | YOUR SEAT IS CONFIRMED     |
| Mike  | YOUR SEAT IS NOT CONFIRMED |
| David | YOUR SEAT IS CONFIRMED     |
| Carol | YOUR SEAT IS NOT CONFIRMED |
| James | YOUR SEAT IS CONFIRMED     |
+-------+----------------------------+

CASE এর ধরন

• Simple CASE: CASE col WHEN val1 THEN ... WHEN val2 THEN ... ELSE ... END
• Searched CASE: CASE WHEN condition THEN ... WHEN condition THEN ... ELSE ... END (এখানে ব্যবহার করা হয়েছে)