247 

   248 def search(dbh, pattern=None, like=False):

   249     sql = 'SELECT domainname FROM domains'

   250     if pattern is None:

   251         pass

   252     elif like:

   253         sql += " WHERE domainname LIKE '%s'" % pattern

   254     else:

   255         sql += " WHERE domainname = '%s'" % pattern

   256     sql += ' ORDER BY domainname'

   257     dbc = dbh.cursor()

   258     dbc.execute(sql)

   259     domains = dbc.fetchall()

   260     dbc.close()

   261     return domains