How to translate an UPDATE WHERE IF @@ROWCOUNT == 0 query from MS SQL to MySQL? -

i have query in following form:

update tablename set some="1", fields="two"  some_condition="true"  if @@rowcount=0 insert tablename(some, fields) values ("1", "two"); 

this query written in ms sql i'd translate mysql. i've looked several refs replace @@rowcount row_count() i'm not sure do.

any ideas of how translate queries ms sql mysql?

a more elegant way of handling like....

if exists(select 1 tablename (updlock, holdlock)            some_condition= "true" )    begin         update tablename             set    = "1"              , fields = "two"          some_condition= "true" ;    end else    begin       insert tablename(some, fields) values ("1", "two");    end