Facebook fql case insensitive version of strpos

Question

What is the case insensitive version of

strpos(field', 'Phrase')

in facebook query language?

This works: strpos(lower(field), 'phrase') > 0. Is this the only way? — Lukasz, Sep 14 '10 at 23:01

score 9 · Accepted Answer · answered Sep 14 '10 at 23:03

9

Your closest bet would be to convert both phrases to lowercase (or uppercase) for the comparison, as follows:

strpos(lower(field),lower(phrase))

answered Sep 14 '10 at 23:03

defines

I just thought there would be something like stripos, similar to in php. ANyway - old trick ;-) thx – Lukasz Sep 14 '10 at 23:49
You would think so, but it wasn't even in PHP until 5. Cheers! – defines Sep 17 '10 at 02:52

score -2 · Answer 2 · answered Sep 14 '11 at 14:29

-2

Try stripos, case insensitive strpos

answered Sep 14 '11 at 14:29

Jayme Dunlap

2 Answers2