How to write WHERE .. LIKE query ?

[Shuge Lee]

Hi all:

How to write WHERE ... LIKE query ?
For examples(described in Python):

Schema:

# columnfamily name
resources = [
   # key
    'foo': {
        # columns and value
        'url': 'foo.com',
        'pushlier': 'foo',
    },
    'oof': {
        'url': 'oof.com',
        'pushlier': 'off',
    },
   #  ... ,
}

# this is very easy,
SELECT * FROM KEY = 'foo'

but following are really hard:
SELECT * FROM resources WHERE key LIKE 'o%' # get all records which key name
contains character 'o'?
SELECT * FROM resources WHERE url == 'oof.com'

Anyone have good ideas  ?

-- 

Lee Li