mysql - SQL SERVER 查询到 MYSQL 查询

Question

我正在尝试将此 MSSQL 查询转换为 MYSQL

查询看起来像这样

select tu.FirstName+' '+tu.LastName as name,tg.Name as game_name,tg.Status,tg.UserId,tg.gameid from tblUsers tu    
inner join tblGame tg on  
tu.UserId=tg.UserId where tg.Name LIKE @Name + '%' 

当我在 MYSQL 上运行相同的查询时，它不返回任何记录，问题是什么？它在 SQL Server 上运行良好

Answer 1

SELECT CONCAT_WS(' ', tu.FirstName, tu.LastName) AS name, tg.Name AS game_name,tg.Status,tg.UserId,tg.gameid
FROM tblUsers tu    
INNER JOIN tblGame tg ON tu.UserId=tg.UserId
WHERE tg.Name LIKE CONCAT(tu.FirstName, ' ', tu.LastName, '%')

注释:

• 不区分大小写，我使用大写只是为了便于阅读
• 我特意使用 concat 和 concat_ws 将它们显示为选项