How to do MySQL update query in r

In MySQL, what I did is:

update table set group = 1 where log(id) < 0

I wanna do same thing in R but I have no idea

What should I do?