Class::DBI's search_like doesn't support the limit stuff.

Have a look at Class::DBI::AbstractSearch, which gives you search_where. That does support order_by and limit, thanks to SQL::Abstract::Limit. See its synopsis for an example.