[步骤]
SELECT CAST(rps.sku AS CHAR) AS sku,rps.sku_name AS product_title,
DATE(COALESCE(rps.update_time, rps.create_time)) AS add_time,
NULLIF(TRIM(rps.image_url), '') AS pic_url
FROM t_pms_product_sku rps
WHERE CAST(rps.sku AS CHAR) IN ('50018140','50018881','50018841','50018821','50019160','50018031','50018820','1416049','50019460','50015262','50019741','50018032','1417094','50019961','50020004','50020180','50020371','50020375','50020376','50020402','50020900','50020761','50020773','50020772','50020521','50021000','50021181','50021182','50021463','50021462','50021560','50021500','50021580','50021584')
AND rps.sku_name IS NOT NULL
AND TRIM(rps.sku_name) != ''
AND rps.sku_name NOT LIKE 'http%%'
ORDER BY COALESCE(rps.update_time, rps.create_time) DESC
LIMIT 100
[结果]
[期望]
去掉 CAST(rps.sku AS CHAR) 类型转换 直接用 rps.sku