Help converting from MS SQL

I don't think some of these functions are available to mySQL.  I am new to using it and wonder if anyone can help.


Here is a much shortened version of the script.  I think it has to do wth the @@rowcount, begin, end syntax...


UPDATE bp_item
                                    SET ItemID=<cfqueryparam cfsqltype="cf_sql_varchar"  value="#thisItem.itemId[1]#">                        
                                    WHERE ItemID= '#thisItem.itemId[1]#'                        
                                    IF @@ROWCOUNT = 0
                                    BEGIN
                                          INSERT INTO item
                                                            (KeywordID)
                                                VALUES
                                                            (<cfqueryparam cfsqltype="cf_sql_integer"  value="#getNextKeywords.keyword_ID#">)
                                    END




Thank you