I have a table in my database called Games. This table has a column called "players_attending" that stores varchars. I need to be able to add a new string into this column while still saving the previous strings.
For example, if one row of Games had players_attending = "bryan." I want to be able to add "matt" to players_attending but also still have bryan.
The result should be players_attending = "bryan matt."
Is this possible?
Your query would be like:
Oracle:
Update table set field = field || ' matt'
MySQL:
Update table SET col=CONCAT(col,' matt');
MSSQL:
Update table set col = col + ' matt'
Yes, you would concatenate the string using ||
update Games
set players_attending = players_attending || ' ' || new_player_name
where Id = x
use concatenation to add two string and the where clause to get the required data records
update table GAMES set field = field || ' ' || 'Matt' where field = 'bryan'
You can update the column by concatenating value to it. SQL Server example
UPDATE YourTable
SET field = CAST(field AS VARCHAR(50)) + CAST('matt' AS VARCHAR(50))
WHERE (condition)
||to concatenate strings:players_attending = players_attending || 'matt'