users = helper.select("SELECT * FROM students WHERE firstName LIKE '%"+window1.txtSearch.text()+"%' OR lastName LIKE '%"+window1.txtSearch.text()+"%' OR middleInitial LIKE '%"+window1.txtSearch.text()+"%' OR age LIKE '%"+window1.txtSearch.text()+"%' OR gender LIKE '%"+window1.txtSearch.text()+"%' OR yearLevel LIKE '%"+window1.txtSearch.text()+"%' OR department LIKE '%"+window1.txtSearch.text()+"%'")

    for row_number,user in enumerate(users):

        window1.tblList.insertRow(row_number)

        for column_number,data in enumerate(user):

            cell = QtWidgets.QTableWidgetItem(str(data))

            window1.tblList.setItem(row_number,column_number,cell)