mysql if update,在MySQL中用IF条件更新...

Hi!

Anyone knows if it''s possible to do an update if, and only if my

condition is TRUE.

Example:

In MYTABLE I have three columns, like this:

ID(INT), PUBLISH(ENUM(Y,N)), PASSWORD(VARCHAR(10))

This is what I want to do:

UPDATE the tablerow with id=333, SET publish=''Y'' IF password=''xxx''

I was trying out the MySQL-expression "IF(expr1,expr2,expr3)" but this

really doesn''t do it!

It could work if it was possible to set a SELECT statement in expr1,

returning NULL or EmptyString. Then if NULL DO(execute) expr2 ELSE

DO(execute) expr3

Like this: IF(SELECT * FROM mytable WHERE id=333 AND

PASSWORD=''xxx'',UPDATE mytable SET publish=''N'' WHERE id=333, UPDATE

mytable SET publish=''Y'' WHERE id=333 )

Any ideas?

解决方案J.P wrote:

This is what I want to do:

UPDATE the tablerow with id=333, SET publish=''Y'' IF password=''xxx''

# This will update row only if the password and id match.

update yourtablename set publish=''Y'' where id=333 and password=''xxx'';

J.P wrote:

This is what I want to do:

UPDATE the tablerow with id=333, SET publish=''Y'' IF password=''xxx''

# This will update row only if the password and id match.

update yourtablename set publish=''Y'' where id=333 and password=''xxx'';

J.P wrote:

This is what I want to do:

UPDATE the tablerow with id=333, SET publish=''Y'' IF password=''xxx''

# This will update row only if the password and id match.

update yourtablename set publish=''Y'' where id=333 and password=''xxx'';