Update Mass Data in Field?
| От | Carlos Mennens |
|---|---|
| Тема | Update Mass Data in Field? |
| Дата | |
| Msg-id | CAAQLLO5fHwYyjtzDs98VAn6FwMW3dnp+uRYYX7-H11OA-WBqnw@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Update Mass Data in Field?
Re: Update Mass Data in Field? |
| Список | pgsql-sql |
I'm new to SQL so I'm looking for a way to change several email addresses with one command. For example everyone has a 'holyghost.org' domain and I need to change a few 100 email addresses in the field 'emp_email'. I need to UPDATE employees table which has a COLUMN 'emp_email' and change %holyghost.org to %ghostsoftware.com. I tried: UPDATE employees SET emp_email = '%ghostsoftware.com' WHERE emp_email LIKE '%holyghost.org'; It didn't update anything when I ran the command. Does anyone know how I need to correct my SQL statement above to change everyone's email address?
В списке pgsql-sql по дате отправления: