title: SQL table column with email address
body: <p>I have a table ‘customers’ with two columns 'email' and ‘value’.  The ‘email’ column contains email addresses and ‘value’ column contains NULL values.  Now I would like to write an Update command, so that if an email is in right format (a@b.c) then SET the ‘value’ column with ‘True’ and if the email address is in wrong format (a.b.c  Or @b.c) then SET the ‘value’ column with ‘False’. Now my question is how I shall write the SQL command to find out which email address is right. Any suggestion please.  Thanks.</p>