[RESOLVED] convert to mySQL?

[mrbaseball34]

Got this code in MSSQL:

update games
set visitorscore = :visitorscore
    homescore = :homescore
where gamenum = :gamenum and
      ((teamnum in  

        ( select homeid from games where gamenum = :gamenum )
      ) or
      (teamnum in  

         ( select visitorid from games where gamenum = :gamenum )
      ))

How can I make something like this work on mySQL 4.0.22??

[Sxooter]

What are the visitorscore = :visitorscore lines meaning? Are those variables or something in a stored proc?

[mrbaseball34]

update games
set visitorscore = @visitorscore, homescore = @homescore
where gamenum = @gamenum and
  (
    (homeid = @teamnum)
    or
    (visitorid = @teamnum)
  )

Here is final code. the variables preceded by @ will be modified like parameters.