By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE products (
`id` INTEGER,
`title` VARCHAR(11)
,
FULLTEXT(title));
INSERT INTO products
(`id`, `title`)
VALUES
('34', 'green book'),
('35', 'book green'),
('84', 'green shirt'),
('22', 'red book');
SELECT * FROM products WHERE match(title) against('+green +book' IN BOOLEAN MODE)
AND title like '%green book%'
| id | title |
|---|---|
| 34 | green book |
SELECT * FROM products WHERE match(title) against('"green book"' IN BOOLEAN MODE)
| id | title |
|---|---|
| 34 | green book |