def output_lastname(message):
con = MySQLdb.connect(db = ‘…’, user = ‘…’, passwd = ‘…’, host = ‘…’, charset = ‘…’)
cur = con.cursor()

try:
mes = message.text
sql = cur.execute('SELECT lastname, firstname, middlename, function, department, intphone, room, extphone FROM table WHERE lastname LIKE “'+ mes +'%”')
data = cur.fetchall()

for rec in data:
lastname, firstname, middlename, function, department, intphone, room, extphone = rec
msg = bot.send_message(message.chat.id, rec)

a = bot.send_message(message.chat.id, ‘Нажмите /search для того, чтобы начать новый поиск!’)

except Exception as e:
bot.reply_to(message, ‘Нет записей’)

a = bot.send_message(message.chat.id, ‘Нажмите /search для того, чтобы начать новый поиск!’)

con.close()