RE: contact gives empty result

ll need to update it with additional text. Best regards, Almar van Pel www.makeweb.nl -Original Message- From: Jaime Crespo Rincón [mailto:jcre...@warp.es] Sent: dinsdag 22 februari 2011 13:20 To: Joerg Bruehe Cc: mysql@lists.mysql.com; Almar van Pel Subject: Re: contact gives empty re

Re: contact gives empty result

2011/2/22 Joerg Bruehe : > You have not understood the concept of NULL in SQL: > NULL does not mean "empty", it means "unknown". [...] Apart form fully agreeing with Joerg, just a tip: you can use the the IFNULL() operand as a workaround:

Re: contact gives empty result

Hi Almar, all! Almar van Pel wrote: > Hello all, > > > > I'm trying to get a TEXT field updated with its own content and an extra > string by using concat. The query looks something like this: > > > > update field_comment set field_comment = concat(field_comment, '\n > my_new_string'); >

contact gives empty result

Hello all, I'm trying to get a TEXT field updated with its own content and an extra string by using concat. The query looks something like this: update field_comment set field_comment = concat(field_comment, '\n my_new_string'); I've noticed that in this case the update doesn't work whe