MySQL

UPDATE where column

[Alternative Future]

Hello to the forum,

MySQL version 4.0.23-standard

I am trying to UPDATE a column in my database WHERE a column = 'value and other column = null with a value.

UPDATE table
WHERE column_a = 'value'
AND
column_b = NULL
create a value in column_b

Any help with the query is appreciated.

TIA,

-George

[txbakers]

UPDATE table set columnB= 'myVal'
WHERE column_a = 'value'
AND
column_b is NULL

[Alternative Future]

Nice one txbakers many thanks for that...

-George