I'm trying to search strings that end with certain characters. How can I do this with the search method?

Searching  ('name', '=', '%abc') doesn't work. If I use like ('name', 'like', '%abc') it does not search the strings that end with 'abc' but all strings that contain 'abc'.     

The search has to be fast so I cannot use another line where I iterate trough the results to get only those that end with the value.