MySQL™: The World’s Most Popular Open Source Database 156 4.0: Handler (Navigation) Interface • Used when porting old database application with a navigational (direct ISAM) interface • Also useful when you are doing a userinterface that navigates a lot of data • This interface gives "Dirty" reads (but no other MySQL commands are affected!) • HANDLER table_name OPEN; • HANDLER table_name READ index_name > ("Banana") LIMIT 10; • HANDLER table_name READ index_name PREVIOUS; Copyright 2003 MySQL AB