Mysql CASE - WHEN - THEN - returning wrong data type (blob)
- by Jack
Hi there.
Im creating customizable product attributes in a web store - each attribute can have different type of data, each data type is stored in a separate column using corresponding mysql datatype.
I Have a query like:
SELECT
products.id AS id,
products.sku AS sku,
products.name AS name,
products.url_key AS url_key,
attributes.name AS…