Untitled
Anonymous
mysql
01/27/2024 4:32 PM
448 B
23
Indexable
(SELECT
product_id, 'store1' AS store, store1 AS price
FROM
Products
WHERE
store1 IS NOT NULL)
UNION
(SELECT
product_id, 'store2' AS store, store2 AS price
FROM
Products
WHERE
store2 IS NOT NULL)
UNION
(SELECT
product_id, 'store3' AS store, store3 AS price
FROM
Products
WHERE
store3 IS NOT NULL)Editor is loading...
Leave a Comment