Calculate time interval in SQL

I have a table where I have 2 fields horainicio and horaafinal I'm wanting to get the results that fits between the initial and final values but without success follows what I'm using.

I'mpickingupthecurrenttimeandtryingtomakethiscomparison

$horaatual=date("H:i");

  SELECT * FROM programacao WHERE horafinal => '$horaatual' ORDER BY Nid DESC LIMIT 1";

Any suggestions? changed the code