SQL服务器查询到MYSQL查询
SQL服务器查询到MYSQL查询
提问于 2011-11-02 18:59:50
我正在尝试将此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上运行良好。
回答 2
Stack Overflow用户
回答已采纳
发布于 2011-11-02 19:06:38
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不区分大小写，我只对readability
- I've使用了大写，我故意同时使用concat和concat_ws来将它们显示为options
Stack Overflow用户
发布于 2011-11-02 19:07:30
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 + '%'
select concat(tu.firstName,' ',tu.lastName) as name, ,tg.Name as
game_name,tg.Status,tg.UserId,tg.gameid from tblUsers as tu
inner join tblGame as tg on
tu.UserId=tg.UserId where tg.Name LIKE concat(@Name,'%');请注意，没有(例如) field1+' '+field2，有concat、concat_ws和group_concat，请阅读它，它非常有用。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/7979221
复制相关文章
相似问题
腾讯云开发者
