Sql query to Clear existing email addresses from table.

please I need help

closed as unclear what you're asking by James Jenkins, LowlyDBA, Philᵀᴹ, John Eisbrener, mustaccio Oct 15 at 17:24

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


I see at least 2 variants .. but you give very little information - even your goal is not obvious.

1) remove email-column

ALTER TABLE "table_name" DROP "column_name";

2) delete email-addresses [ with restriction to a specific address

UPDATE "table_name" SET email_address=null [ WHERE email_address='jane.doe@example.com']
  • thank for the reply.there are 4 different email address fields Email_fax, Email_num, Email2, email_add3. so for all of them i have to do same queries ? there are numbers of different email addresses and all of them need to be clear. – ajay Oct 15 at 15:29
  • you can include those in the update statement .. it allows changing of more than one column ... but needs some work in the where part as well >where column1=x or column2=x or column3=x ... in that pattern – eagle275 Oct 17 at 6:53

Not the answer you're looking for? Browse other questions tagged or ask your own question.