Back to YQL Forum
0

Any chance of an upper?

No, it's not a request for some chemical assistance during a bleak winter.
I'm looking for a case-insensitive match that doesn't require a wild card prefix or suffix. Using something like 'upper(element) = "MATCH TERM"' would fit the bill.

by
Report Abuse
2 Replies
  • QUOTE (hapdaniel @ Jan 10 2009, 04:29 PM) <{POST_SNAPBACK}>
    No, it's not a request for some chemical assistance during a bleak winter.
    I'm looking for a case-insensitive match that doesn't require a wild card prefix or suffix. Using something like 'upper(element) = "MATCH TERM"' would fit the bill.


    Looks like a valid request. Thanks! We'll certainly evaluate it.
    One way to do this today (as you've already guessed) is by using a combination of prefix and suffix. The starts with and endswith matches are case-insensitive in YQL.

    CODE
    ... where title like '%MATCH TERM' and title like 'MATCH TERM%'


    -- Nagesh
    Report Abuse
    0
  • QUOTE (Nagesh Susarla @ Jan 10 2009, 11:54 PM) <{POST_SNAPBACK}>
    Looks like a valid request. Thanks! We'll certainly evaluate it.
    One way to do this today (as you've already guessed) is by using a combination of prefix and suffix. The starts with and endswith matches are case-insensitive in YQL.

    CODE
    ... where title like '%MATCH TERM' and title like 'MATCH TERM%'


    -- Nagesh

    Thanks to the new update I can now do
    CODE
    where title matches '(?i)MATCH TERM'


    Great stuff!
    Report Abuse
    0
Ask a Question

Recent Posts

in YQL