MySQL :: How to return update value?

INSERT INTO a (b,c) VALUES (x,y) ON DUPLICATE KEY UPDATE c=c+1

[majjk]

I'm doing the following:

INSERT INTO ordernumber (id,count) VALUES (123,1) ON DUPLICATE KEY UPDATE count=count+1

what I would like to know is what the "count" value is after this operation. is it possible to include some kind of SELECT in this query so that I will know what the "count" value is in the end?

ideas?

[ZydoSEO]

Have you tried:

INSERT INTO ordernumber (id,count) VALUES (123,1) ON DUPLICATE KEY UPDATE count=count+1

SELECT ROW_COUNT();

See ROW_COUNT() function description [dev.mysql.com...]