Google searching with SQL

A co-worker over at chacha and I were talking one day and decided it would be "cool" to be able to search google with select statement (note the sarcastic air quotes around "cool"?)

For example, why not write a select statement like so:

SELECT * FROM google g
WHERE g.query = 'barack obama'
and g.title like '%policy%' and g.text like '%economic%'
and g.site <> 'wsj.com'
and g.filetype in ('html') and g.filetype <> 'jpg';

... instead of using the google advanced search format (which becomes '"barack obama" intitle:*policy* intext:*economic* -site:wsj.com filetype:html -filetype:jpg')

Now you can! I took about 3 hours and a few open source sql parsing modules and created sqlsear.ch. You simply type in a select statement (the 'where' clause is all that matters right now) and sqlsear.ch converts it to google's advanced search syntax and runs the search for you!

Special thanks to the sweds for the .ch top-level domain extension and for letting me purchase it!

Go on over and give it a try. Drop me a line if you can think of anything you want improved/changed/fixed or whatever.

- Jon