How to use inserted value of field in SOQL's where clause?

Question

Hello, I want to use inserted value of field in the from  in SOQL's where clause. How can I access the inserted value of field?

Suraj Tripathi · Answer

Hi Kaushik Dhiman 1,

You can use Where Clouse as follows.

1. SELECT Id FROM Contact WHERE LastName = 'foo' or Account.Name = 'bar'

2. SELECT AccountId, FirstName, lastname FROM Contact WHERE lastname LIKE 'appl%'

3. SELECT Name FROM Account WHERE BillingState IN ('California', 'New York')

4. SELECT Name FROM Account WHERE BillingState NOT IN ('California', 'New York')

If you find your Solution than mark it as a best answer.

Thanks and Regards

Suraj Tripathi.

Apex