You can use the UPDATE or DELETE command
they work a little different, DELETE works like select, where you specify a specific row or everything will be deleted. In UPDATE, you have to be very specific,
UPDATE set password = $password where username = $username.
or if you want to do all of them it would be
UPDATE set password = $reset, all rows will be effected, so be carefull with these two commands.