select * from personnel where (replace(replace(replace(concat(firstName,lastName),' ',''),'.',''),'\'','') = 'michaelhardin')
select * from personnel where (replace(replace(replace(concat(firstName,middleName,lastName),' ',''),'.',''),'\'','') = 'michaelhardin')
select * from personnel where (email LIKE '%michaelhardin@cba.ua.edu%')