Using YQL how can I select an item from a feed that contains a colon in its name?

Question

I'm using YQL to parse some web feeds, this one in particular.

SELECT * FROM rss WHERE url='http://www.arena.net/blog/feed'

This query returns a bunch of fields, one of which looks like

content:encoded

How can I select that field to filter? I want to do something like this,

SELECT title, link, pubDate, content:encoded FROM rss WHERE url='http://www.arena.net/blog/feed'

but that is invalid. I've tried escaping with a slash without any luck.

Answer 1

Put the field name in back-quotes, of all things:

SELECT title, link, pubDate, `content:encoded` FROM rss
 WHERE url='http://www.arena.net/blog/feed'

Should work

Answer 2

SELECT title, link, pubDate, encoded
FROM rss
WHERE url='http://www.arena.net/blog/feed' 

Here's a console link.