ON DUPLICATE KEY UPDATE (but only if value isn't an empty string)

[smoth]

I have this SQL:

"INSERT INTO tbl_guilds (name,parent) VALUES (@guild, @astroLocation) ON DUPLICATE KEY UPDATE name=@guild, parent=@astroLocation";

What I want is saying something like:

"INSERT INTO tbl_guilds (name,parent) VALUES (@guild, @astroLocation) ON DUPLICATE KEY UPDATE name=@guild, parent=@astroLocation IF @guild IS NOT NULL";

Anyone got any suggestions?

[gk53]

look on merge like that

MERGE INTO tbl_guilds B
USING (
  SELECT (@guild as guiId_New, @astroLocation as astroLocationNew ) E
ON (B.name= E.guiId_New)
WHEN MATCHED and E.guiId_New is not null THEN
  UPDATE SET B.parent = E.astroLocationNew
WHEN NOT MATCHED THEN
  INSERT (B.name, B.parent)
  VALUES (E.guiId, E.astroLocationNew);

[smoth]

Sorry, I forgot to say that I'm using MySql 5.0 so MERGE won't work.. Thanks for the reply though.. I might be able to figure something out from it..