jose isaias cabrera <[EMAIL PROTECTED]>
wrote:
I would like is to do something like this,
UPDATE table SET
ID = '88' if not = '88',
Just have
ID = '88'
Overwriting a value with the same value is harmless.
parent = '1171291314642' if null,
parent = ifnull(parent, '1171291314642')
Same idea. Unless "parent" is null, this just does parent=parent
children = '',
login = 'blah',
notes = 'blah-blah' if null,
status = 'o'
WHERE ProjID = '88';
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
