LIKE Operator in SOQL

The LIKE operator is used to filter records based on a field starts/ends with or contains a specific keyword. The like operators are useful to find records with partial matches.

In the above example:

• The LIKE operator is used after a field name (e.g., Subject) to find records with a specific string.
• The character % is used to indicate how to match the string on the field.
• %String Finds fields that start with the string.
• String% Finds fields that end with the string.
• %String% Finds fields that contain the string anywhere.

Try It Yourself

Try It Yourself