Converted SOSL from SOQL is not working

Question

SOQL query

SELECT Id, Name FROM Opportunity
    WHERE College__r.Phone LIKE '%7411162213'
        OR College__r.OtherPhone LIKE '%7411162213'

on running on developer console it gives result total rows fetched 1

I want its equivalent SOSL query. I converted to following:

FIND {7411162213} IN ALL FIELDS
    RETURNING Opportunity(Id, Name WHERE College__r.Phone LIKE '%7411162213'
                                       OR College__r.OtherPhone LIKE '%7411162213')

but this does not give me any result on developer console. Total rows fetched is 0.

Am I missing anything in above SOSL query?

Answer 1

Ok, so assuming you are actually after SOSL:

First, you can't have relationship fields. So replace them with calculated fields. (Ie, College__r.OtherPhone becomes CollegeOtherPhone__c

Secondly, you don't need the WHERE clause - you are already searching by the same value in the find part. If you DID want to filter a bit more, you'd do that in the WHERE clause, but you'd be excluding records based on different criteria.

Which leaves you with something like this:

FIND {7411162213} IN ALL FIELDS 
RETURNING Opportunity(Id, Name, CollegePhoneCalc__c, OtherPhoneCalc__c )