5.28`LIKE`

Example:

SELECT Id, Name
FROM Account
WHERE Name LIKE 'Acme%'

Meaning approximately:

starts with Acme

Or:

WHERE Email LIKE '%@example.com'

Again, resembles SQL.