[步骤]

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