Question about query involving null values

[Jeffrey Roden]

I'm new to MySQL and am just migrating from Microsoft Access. Obviously, the way Access and MySQL handle queries is different. I have a people table where I have names in 3 columns, being LastName, FirstName and PreferredFirstName. In Access, I concatenate these in a query to produce the result FullPreferredName. Here's my Access query:

SELECT
IIf([PreferredFirstName] Is Not Null,
[LastName] &", "&[PreferredFirstName],
[LastName] &", "&[FirstName]
AS
FulPreferredName

Obviously, the MySQL statements will be different, as well as how it concatenates columns together. I've search everywhere and can't seem to get it right. Thanks in advance for the help.