Does facebook fql contain the sql like operator?

Question

Hi all,

I am building a small facebook app. Trying to search for values in an auto compelte manner. Is it possible to use sql's like operator in fql?

Answer 1

There is no LIKE operator in FQL.

However, you may have luck with the IN operator:

WHERE "Stanford" IN education_history.name

These two pages may be helpful:

• FQL
• Sample FQL Queries

Answer 2

Another way for you is to use the strpos(message, "content you want") >= 0. I don't know why, but the IN operator does not run for me. Did anyone try it?