Hi there! 

I'm new at Salesforce and I'm trying to debug a class but I'm receiving this error "System.QueryException: unexpected token: 'LIMIT' at line 24, column 1. Can anyone advise what is wrong_ as I cannot seem to find the answer, thanks 

public with sharing class dvd_CustomLookupController {

    @AuraEnabled(cacheable=true)
    public static List<sObject> search(String searchTerm, String searchField, string myObject, String filter) {
        
        String myQuery = null;
        String searchFieldWhere;
        system.debug(searchTerm+':'+searchField+':'+myObject+':'+filter);
        if(String.isBlank(searchField)){
            searchField = ' ';
            searchFieldWhere = 'Name';
        }else{
            searchFieldWhere = searchField;
            searchField = ' ,' + searchField;
        }
        if(String.isNotBlank(filter)){
            myQuery = 'Select Id, Name '+searchField+' from '+myObject+' Where '+searchFieldWhere+' Like  \'%' + searchTerm + '%\' AND '+filter+' LIMIT  5';
        }else {
            if(String.isBlank(searchTerm)){
                myQuery = 'Select Id, Name '+searchField+' from '+myObject+' Where LastViewedDate != NULL ORDER BY LastViewedDate DESC LIMIT  5';
                
            }else {
                myQuery = 'Select Id, Name '+searchField+' from '+myObject+' Where '+searchFieldWhere+' Like \'%' + searchTerm + 'DESC LIMIT  5';
            }
        }
        List<sObject> lookUpList = database.query(myQuery);
        system.debug(myQuery);
        
        system.debug(lookUpList.size());
        return lookUpList;
    }
}

Hi there! 

I'm new at Salesforce and I'm trying to debug a class but I'm receiving this error "System.QueryException: unexpected token: 'LIMIT' at line 24, column 1. Can anyone advise what is wrong_ as I cannot seem to find the answer, thanks 

public with sharing class dvd_CustomLookupController {

    @AuraEnabled(cacheable=true)
    public static List<sObject> search(String searchTerm, String searchField, string myObject, String filter) {
        
        String myQuery = null;
        String searchFieldWhere;
        system.debug(searchTerm+':'+searchField+':'+myObject+':'+filter);
        if(String.isBlank(searchField)){
            searchField = ' ';
            searchFieldWhere = 'Name';
        }else{
            searchFieldWhere = searchField;
            searchField = ' ,' + searchField;
        }
        if(String.isNotBlank(filter)){
            myQuery = 'Select Id, Name '+searchField+' from '+myObject+' Where '+searchFieldWhere+' Like  \'%' + searchTerm + '%\' AND '+filter+' LIMIT  5';
        }else {
            if(String.isBlank(searchTerm)){
                myQuery = 'Select Id, Name '+searchField+' from '+myObject+' Where LastViewedDate != NULL ORDER BY LastViewedDate DESC LIMIT  5';
                
            }else {
                myQuery = 'Select Id, Name '+searchField+' from '+myObject+' Where '+searchFieldWhere+' Like \'%' + searchTerm + 'DESC LIMIT  5';
            }
        }
        List<sObject> lookUpList = database.query(myQuery);
        system.debug(myQuery);
        
        system.debug(lookUpList.size());
        return lookUpList;
    }
}