SELECT *
FROM borrowers
WHERE
     (((
         (borrowers.firstname = ?  OR borrowers.firstname LIKE ?  OR borrowers.firstname LIKE ?)
      OR (borrowers.surname = ?  OR borrowers.surname LIKE ?  OR borrowers.surname LIKE ?)
      OR (borrowers.email = ?  OR borrowers.email LIKE ?  OR borrowers.email LIKE ?)
      OR (borrowers.othernames = ?  OR borrowers.othernames LIKE ?  OR borrowers.othernames LIKE ?)
      OR (borrowers.cardnumber = ?  OR borrowers.cardnumber LIKE ?  OR borrowers.cardnumber LIKE ?)
     )))
  OR ((
        (( borrowers.branchcode = ?  OR borrowers.branchcode= '' OR borrowers.branchcode IS NULL OR borrowers.branchcode LIKE ?  OR borrowers.branchcode LIKE ? ))
    AND (( borrowers.categorycode = ?  OR  borrowers.categorycode= '' OR borrowers.categorycode IS NULL OR borrowers.categorycode LIKE ?  OR borrowers.categorycode LIKE ? ))
     ))
ORDER BY surname, firstname