The SFrame supports all things that python string comparison does. So, if you had a string in python
user = 'foo'
user == 'foo*' will return False. Likewise, the == operator in the SFrame would return false.
You can use the SArray.apply (see the API docs) to do so. I would do
sa = gl.SArray(["foo","bar", "foo1"])
func = re.compile('foo*')
sa_new = sa.apply(lambda x: func.search(x) != None)