"( a | b ) c"                           -- Either "a c" or "b c"
"( ( a b c ) | d ) e"                   -- Either "a b c e" or "d e"  
"man ( happy | sad ) but all ( ( as good ) | ( as fast ) )"  -- Complex nested possibilities

-- Clean slate for easy reproduction
DROP TABLE IF EXISTS phrase_or_demo;

CREATE TABLE phrase_or_demo (title TEXT, content TEXT, category TEXT);

INSERT INTO phrase_or_demo (id, title, content, category) VALUES 
(1, 'Happy Customer Review', 'I am a very happy customer with excellent service', 'reviews'),
(2, 'Sad Customer Feedback', 'I am a very sad customer with poor experience', 'reviews'), 
(3, 'Customer Service Report', 'The customer was happy but had some concerns', 'reports'),
(4, 'Angry Customer Complaint', 'I am an angry customer demanding refund', 'complaints'),
(5, 'Neutral Customer Survey', 'The customer seemed neutral about our service', 'surveys'),
(6, 'Fast Delivery Service', 'Our delivery service is really fast and reliable', 'services'),
(7, 'Slow Delivery Issues', 'The delivery was extremely slow this time', 'issues'),
(8, 'Good Service Quality', 'We provide good service to all customers', 'services'),
(9, 'Bad Service Report', 'There were complaints about bad service quality', 'reports'),
(10, 'Customer Happy Experience', 'The happy customer left positive feedback', 'feedback'),
(11, 'Premium Quality Product', 'This is a premium quality item with excellent features', 'products'),
(12, 'Budget Quality Option', 'A budget quality alternative for cost-conscious buyers', 'products'),
(13, 'Standard Quality Service', 'Our standard quality offering meets basic needs', 'services');

SELECT * FROM phrase_or_demo WHERE MATCH('"(happy | sad | angry) customer"')

+------+---------------------------+---------------------------------------------------+------------+
| id   | title                     | content                                           | category   |
+------+---------------------------+---------------------------------------------------+------------+
|    2 | Sad Customer Feedback     | I am a very sad customer with poor experience     | reviews    |
|    4 | Angry Customer Complaint  | I am an angry customer demanding refund           | complaints |
|    1 | Happy Customer Review     | I am a very happy customer with excellent service | reviews    |
|   10 | Customer Happy Experience | The happy customer left positive feedback         | feedback   |
+------+---------------------------+---------------------------------------------------+------------+
4 rows in set (0.00 sec)

SELECT * FROM phrase_or_demo WHERE MATCH('"(good | bad | premium | budget | standard) (service | quality)"');

+------+--------------------------+--------------------------------------------------------+----------+
| id   | title                    | content                                                | category |
+------+--------------------------+--------------------------------------------------------+----------+
|    8 | Good Service Quality     | We provide good service to all customers               | services |
|    9 | Bad Service Report       | There were complaints about bad service quality        | reports  |
|   11 | Premium Quality Product  | This is a premium quality item with excellent features | products |
|   12 | Budget Quality Option    | A budget quality alternative for cost-conscious buyers | products |
|   13 | Standard Quality Service | Our standard quality offering meets basic needs        | services |
+------+--------------------------+--------------------------------------------------------+----------+
5 rows in set (0.00 sec)

-- Find documents with at least 2 out of these word groups
SELECT id, content FROM phrase_or_demo  WHERE MATCH('@content "(excellent | good | premium) (service | quality | experience) customer"/2');

+------+--------------------------------------------------------+
| id   | content                                                |
+------+--------------------------------------------------------+
|    8 | We provide good service to all customers               |
|    1 | I am a very happy customer with excellent service      |
|   11 | This is a premium quality item with excellent features |
|    2 | I am a very sad customer with poor experience          |
|    5 | The customer seemed neutral about our service          |
+------+--------------------------------------------------------+
5 rows in set (0.00 sec)

-- Match documents with at least 50% of these emotion/service combinations
SELECT id, title FROM phrase_or_demo 
WHERE MATCH('"(happy | satisfied) (customer | experience) (excellent | good) (service | quality)"/0.5');

-- Find "delivery" within 3 words of either "fast" or "slow"
SELECT id, title, content FROM phrase_or_demo WHERE MATCH('"(fast | slow) delivery"~3');

+------+-----------------------+--------------------------------------------------+
| id   | title                 | content                                          |
+------+-----------------------+--------------------------------------------------+
|    7 | Slow Delivery Issues  | The delivery was extremely slow this time        |
|    6 | Fast Delivery Service | Our delivery service is really fast and reliable |
+------+-----------------------+--------------------------------------------------+
2 rows in set (0.00 sec)

-- Customer and emotional state within 5 words, plus quality terms
SELECT id, title, content FROM phrase_or_demo  WHERE MATCH('"customer (happy | sad | angry)"~2 (quality | service | experience)');

+------+---------------------------+---------------------------------------------------+
| id   | title                     | content                                           |
+------+---------------------------+---------------------------------------------------+
|   10 | Customer Happy Experience | The happy customer left positive feedback         |
|    2 | Sad Customer Feedback     | I am a very sad customer with poor experience     |
|    1 | Happy Customer Review     | I am a very happy customer with excellent service |
|    3 | Customer Service Report   | The customer was happy but had some concerns      |
+------+---------------------------+---------------------------------------------------+
4 rows in set (0.00 sec)

-- The old way: multiple separate queries
SELECT id, title FROM phrase_or_demo WHERE MATCH('"happy customer"|"sad customer"|"angry customer"');

-- The elegant way: one query to rule them all
SELECT id, title FROM phrase_or_demo WHERE MATCH('"(happy | sad | angry) customer"');

-- Capture all color and size variations
"(red | blue | green | black) (shirt | t-shirt | tee) (small | medium | large)"

-- Track document status changes
"(draft | published | archived | deleted) (document | article | post)"

-- Categorize support issues with quorum
"(urgent | critical | high) (priority | importance) (bug | issue | problem)"/2

-- Capture brand mentions with emotional context  
"@brand (love | hate | like | dislike) (product | service | experience)"~5

-- Find patient symptoms with proximity
"patient (experienced | reported | complained) (pain | discomfort | symptoms)"~4

-- Track transaction types and statuses
"(credit | debit | transfer) (completed | pending | failed | cancelled)"

@title "(urgent | critical) (update | patch)" @body "security"

"(run | running | runner | runs) (fast | quick | speed)"/1

"user (wants | needs | requires) (feature | functionality)"~3