SOQL Query Question

Question

I want to check the surname matching lastname and Pcode matching MailingPostalCode in the query of SOQL.

public class ContactSearch 
{
    public static list<contact> searchForContacts(String Surname,String PCode)
    {   
        list<Contact> Listquery = [select ID, Name, LastName, MailingPostalCode from contact 
                                  where lastName IN : Surname];
    }

}

Answer 1

If you need to extract the records exactly matching the Surname and PCode simply apply a filter for them.

public class ContactSearch 
{
    public static list<contact> searchForContacts(String Surname,String PCode)
    {   
        list<Contact> listQuery = [select ID, Name, LastName, MailingPostalCode from contact 
                                  where lastName =: Surname AND MailingPostalCode=: PCode];

        return listQuery;
    }

}

Answer 2

To search using wildcard LIKE operator use something like

list<Contact> Listquery = 'SELECT ID, Name, LastName, MailingPostalCode FROM contact WHERE lastName LIKE ' + Surname + '%' AND MailingPostalCode =: ' + Pcode

Or you could use exact match SurName by just changing one line, as given below, from above query: WHERE lastName =:' + Surname

Answer 3

I think you have compare two fields LastName & Surname for matching data right ?

List<contact> Listquery = database.query('select ID, Name, LastName, MailingPostalCode from contact where lastName =: Surname');

I think you getting error for IN operator just remove it and put =:

Try This in developer console

List<String> surname = new List<String>();
surname.add('Rogers');
List<String> Pcode= new List<String>();
Pcode.add('27215');
List<contact> C =[select ID, Name, LastName, MailingPostalCode from contact where lastName IN : Surname or MailingPostalCode In : PCode];
system.debug(C);

Might be this useful for you if i am wrong then correct me.