Menu
Community /Pin to ProfileBookmark
@NogDogFeb 13.2011 — #From [url=http://developer.yahoo.com/yql/guide/filters.html]this page[/url] , it looks like you can do that, but be aware that any LIKE comparison is a "local" filter, which -- if I understand it correctly -- means you'll get the entire data set that matches without that filter first, and then it will be filtered "locally", which may be a performance impact. But you should be able to do it and try some testing to see how well it performs.
YQL and Placenames and Instant Searching
I’ve create a rather cool JS object that mimics google’s instant search (at least in its user interface) exactly, but what I’m looking to do is to be able to use it in real world situations. It works beautiful in my testing using the world.sql database. So here’s what I’m looking to do:
I want to let users add weather locations (I am currently pulling in weather using Yahoo’s API). So basically, as the user is typing I want to search using YQL and come up with all the possible locations they are looking for, something like:
select woeid from geo.places where locationType = ‘Town’ and name like ‘query%’;
(I know ‘name’ is not the proper field name, and locationType probably isn’t either, but you get my drift)
Is it possible to use YQL with wildcards?
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogFeb 13.2011 — #From