I have a email column and each row has different number of email. I want to add same email end of to each row. For example;
[email protected];[email protected]
[email protected]
[email protected];[email protected];[email protected]
. . . What I want is;
[email protected];[email protected];[email protected]
[email protected];[email protected]
[email protected];[email protected];[email protected];[email protected]
how can I add ?
You will have to add your own table and column names but it sounds like a simple update
update tablename set column = column + ';[email protected]'
If you only want certain rows updated then add a:
where column like '%search condition%'
You didn't provide any information about database (MySQL, SQL Server, etc.). My solution is for SQL Server
update [tablename] set [column] = concat([column] + ';', '[email protected]')
Why using concat and "+"? Beacause if your table has record with column set to null then operation column + ';' returns also null. After that concat null with string give you that string so you avoid placing unnecesery semicolon at the begining in this case. If column in row has no null in column then column + ';' will add semicolon before your new email address.
