how to joint to varchar field to display as one field,

Dear forum member,

 

I have table having field like 

UserID    FName    MName    LName Gender

 1          John         Mark       Henery  male

I want to write query in MySQL to Display Like 

UserID    Name                          Gender

1            John Mark henery          Male

below code is working in SqlServer where as not in MySql 

select UserID , Fname+' '+Mname+' '+lname as StName from  Test  how to write in
MySql ,

try to use a concationation function: CONCAT (str1,str2,...)

Can you explain with some example

Any ways Thanks for your reply

select UserID , CONCAT(Fname,Mname, lname) as StName from  Test :)

This way is not working in MySQL, it giving error like FUNCTION concat does not
exist