MySQL使用基于其他列的正则表达式填充列

I would like to fill a column IF it is NULL with a regex. It is a email column, and I want to fill it with the : table.name+"."+table.firstname+"@"+"gmail.com" .I would like to fill a column IF it is NULL wit