Wednesday, February 22, 2012

[MYSQL]update concate ignore null

update user_ set
screenName=concat(firstName,IFNULL(lastName, ""))

No comments: