mysql数据库语句的case when用法，以及数据替换，字符串拼接，时间格式转换的用法

本文探讨了金融科技领域的关键组成部分，包括网贷、众筹、征信等新兴金融模式，并深入分析了这些模式如何改变传统金融市场，同时讨论了相关政策及支付解决方案的发展现状。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


/*FB2D8753-3E01-465F-9628-0C9ABAAE6427	新闻(新闻,平台,网贷)
FB2D8753-3E01-465F-9628-0C9ABAAE6427	网贷

423B882E-FEA6-4084-AA6D-0BC34B201715	众筹

7FEEEB0E-945E-4EBA-AE59-61186CAE3BFC	征信

C692EB60-766A-4E23-8B9E-F49C7C7D0195	支付

C7C919B0-D3EC-4704-A20A-4AFA08CB0F55	政策

5EBFB64A-C32A-4872-B033-1465B5DA3359	传统金融
（'股票','银行','基金','信托','国际'）
3DFFD692-F1B2-4279-B510-357240F120CD	数据*/


SELECT
UUID() AS InfoContentID, 
    
(CASE g.catname

	when '新闻' THEN 'FB2D8753-3E01-465F-9628-0C9ABAAE6427'
	WHEN '平台' THEN 'FB2D8753-3E01-465F-9628-0C9ABAAE6427'
        WHEN '网贷' THEN 'FB2D8753-3E01-465F-9628-0C9ABAAE6427'
        WHEN '众筹' THEN '423B882E-FEA6-4084-AA6D-0BC34B201715'

        WHEN '征信' THEN '7FEEEB0E-945E-4EBA-AE59-61186CAE3BFC'

        WHEN '支付' THEN 'C692EB60-766A-4E23-8B9E-F49C7C7D0195'

        WHEN '政策' THEN 'C7C919B0-D3EC-4704-A20A-4AFA08CB0F55'

        WHEN '股票' THEN '5EBFB64A-C32A-4872-B033-1465B5DA3359'

        WHEN '银行' THEN '5EBFB64A-C32A-4872-B033-1465B5DA3359'

        WHEN '基金' THEN '5EBFB64A-C32A-4872-B033-1465B5DA3359'

        WHEN '信托' THEN '5EBFB64A-C32A-4872-B033-1465B5DA3359'

        WHEN '国际' THEN '5EBFB64A-C32A-4872-B033-1465B5DA3359'

        WHEN '数据' THEN '3DFFD692-F1B2-4279-B510-357240F120CD'

        ELSE ''
    END) AS COLID,

    t.uid AS BelongToUserID,

    t.title AS InfoTitle,

    t.title AS InfoSubTitle,

    t.summary AS InfoShortDesc,

    replace( c.content, 'data/attachment/', 'http://www.licaizhijia.com/data/attachment/' )   AS InfoCon,
    t.tag AS KeyWord,

    t.summary AS PDL,

    (case  ifnull(t.pic,'') when '' then '' else
    
	CONCAT('http://www.licaizhijia.com/data/attachment/',t.pic) end)  AS Picture,

    (case  ifnull(t.pic,'') when '' then '' else

	CONCAT('http://www.licaizhijia.com/data/attachment/',t.pic,'.thumb.jpg') end) AS HomePicture,
    t.fromurl AS LinkUrl,

    FALSE AS IsLink,

    1 AS Status,

    1 AS IsTop,

    t.from AS Source,

    t.author AS Author,

    0 AS PV,

    0 AS CommentNum,

    '' as Remark,
    999 AS OrderIndex,

    t.uid AS UpdateUserID,

     FROM_UNIXTIME( t.dateline, '%Y-%m-%d %H:%i:%S') AS UpdateDate,

    t.uid AS CreatedUserID,

     FROM_UNIXTIME( t.dateline, '%Y-%m-%d %H:%i:%S') AS CreateDate,

    t.aid AS IdentityID
 
FROM

    pre_portal_article_title AS t

    LEFT JOIN
    pre_portal_article_content AS c ON t.aid = c.aid

    LEFT JOIN
    pre_portal_category AS g ON t.catid = g.catid  
 where g.catname in('新闻','平台','网贷','众筹','征信','支付','政策','股票','银行','基金','信托','国际','数据')

order by t.aid;