MySQL - Variables in Query similar to PHP -

i have code on php:

$query = "delete ponteved_admincs." . $_get['servidor'] . " auth = '" . $_get['auth'] . "';update ponteved_foroipb.members set member_group_id = 3 member_id = '" . $_get['foroid'] . "' limit 1"; mysqli_multi_query($con,$query); 

this code removes db specified user passed get, , changes user groups on ipb forum. there way variables in query if try on mysql event?

i have on mysqlevent:

delete ponteved_admincs.27015 date(vencimiento) <= date(now()) 

example i'd do, don't know:

var @getuserid = select `foroid` `27015` `auth` = 'green'; delete ponteved_admincs.27015 date(vencimiento) <= date(now()) update ponteved_foroipb.members set member_group_id = 3 member_id = '@getuserid' 

thanks!