SQL SERVER QUERY to MYSQL QUERY

Question

I am trying to convert this MSSQL QUERY to MYSQL

Query looks like this

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 + '%'

the same query doesnt return any records when i run it on MYSQL, what is the issue ? It works good on SQL server

Maxim Krizhanovsky · Accepted Answer · 2011-11-02 11:06:37Z

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, '%')

Notes:

it's case insensitive, I've used upper case just for readability
I've intentionally used both concat and concat_ws to show them as options

answered Nov 2, 2011 at 11:06

Maxim Krizhanovsky

26.8k5 gold badges62 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

eeerahul · Accepted Answer · 2011-11-30 05:16:24Z

0

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,'%');

Note that, there is not (for example) field1+' '+field2, There is concat, concat_ws, and group_concat, read about it, it's super useful.

edited Nov 30, 2011 at 5:16

eeerahul

1,6254 gold badges27 silver badges41 bronze badges

answered Nov 2, 2011 at 11:07

Avni Yayin

4592 gold badges8 silver badges18 bronze badges

Collectives™ on Stack Overflow

SQL SERVER QUERY to MYSQL QUERY

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related