mysql - 使用 MySQL SELECT 将第一个字母更改为大写

Question

This question向我展示如何创建一个函数，然后更新一个表，使列首字母大写，这非常复杂？我只想输出名字和姓氏首字母大写的结果。现在它们是所有大写、小写或正确格式的混合。

SELECT FirstName, LastName, r.Email, min(ListingID) as ListingID, ListingFirmID
    FROM sancap_Residential_Property e 
    JOIN sancap_Agent r ON e.ListingAgentID = r.AgentID
    JOIN sancap_Office d ON e.ListingFirmID = d.firmID
    WHERE ListingFirmID != 'BrokerC'
GROUP BY FirstName, LastName, r.Email, ListingFirmID

Answer 1

试试这个:

SELECT concat(UPPER(SUBSTRING(trim(FirstName),1,1)),lower(SUBSTRING(trim(FirstName),2))) as FirstName, concat(upper(substring(trim(LastName),1,1)),lower(substring(trim(LastName),2))) as LastName, r.Email, min(ListingID) as ListingID, ListingFirmID
    FROM sancap_Residential_Property e 
    JOIN sancap_Agent r ON e.ListingAgentID = r.AgentID
    JOIN sancap_Office d ON e.ListingFirmID = d.firmID
    WHERE ListingFirmID != 'BrokerC'
GROUP BY FirstName, LastName, r.Email, ListingFirmID