MySQL using classes

class.py

import MySQLdb

user = "root"
passwd = ""
db = "test"
host = "localhost"

DB = MySQLdb.connect(user=user, passwd=passwd, host=host, db=db)
C = DB.cursor()

class User(object):
    def __init__(self, userid, username=None, email=None, password=None, date=None):
        self.id = userid
        self.username = username
        self.email = email
        self.password = password
        self.date = date

def find(field,value)
    x = []
    c.execute("""SELECT * FROM users WHERE %s = '%s' """ % (field, value))
    for id, username, email, password, date in c.fetchall():
        u = User(id,username,email,password,date)
	x.append(u)
    return x