SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE modx_ms2_product_options ( id int, value varchar(64) ); INSERT INTO modx_ms2_product_options(id, value) VALUES (1, "Для бани"), (2, "Для бани"), (1, "Для стен"), (1, "Для пола"); SELECT id, GROUP_CONCAT(value) FROM modx_ms2_product_options GROUP BY id HAVING GROUP_CONCAT(value) = 'Для бани';
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear