APPENDING HELP

[dadms]

I have a MySQL database with a notes field. I am not sure how to do the following:

I would like to add text to the field without overwriting what is currently there.

Is there an append command? Could somebody give me an example.

Thanks

 

[cLFlaVA]

SELECT 'this ' + 'is ' + 'how ' + 'you ' + 'append.';

*cLFlaVA
----------------------------
[tt]tastes great, less filling.[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[dadms]

still a bit lost should of asked the whole question...

If I am updating a field I use the UPDATE command,
how would I incorporate the SELECT/append command with the update.

Thanks

 

[cLFlaVA]

wow.

UPDATE tableName
   SET columnName = 'blah ' + 'blah ' + 'blah'
 WHERE columnNameN = 'blag'

*cLFlaVA
----------------------------
[tt]tastes great, less filling.[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[r937]

cLFlaVA, you're thinking of some other database

concatenation in mysql uses the CONCAT function

UPDATE tableName
SET columnName = concat('blah','blah','blah')
WHERE columnNameN = 'blag'

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[cLFlaVA]

um...
whoops.

*cLFlaVA
----------------------------
[tt]tastes great, less filling.[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[cLFlaVA]

damn embarrassing, must have thought i was in sql server forum. sorry about that.

*cLFlaVA
----------------------------
[tt]tastes great, less filling.[/tt]
[URL unfurl="true"]http://www.coryarthus.com/[/url]

 

[r937]

no prob, i've done it too (lots)

;-)

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)