SELECT * FROM gjjbook_db.accounts WHERE
concat_ws('', name, middleName, surName) LIKE '%cagejohn%' OR
concat_ws('', surName, middleName, name) LIKE '%cagejohn%' OR
concat_ws('', name, surName, middleName) LIKE '%cagejohn%' OR
concat_ws('', middleName, surName, name) LIKE '%cagejohn%' OR
concat_ws('', middleName, name, surName) LIKE '%cagejohn%' OR
concat_ws('', surName, name, middleName) LIKE '%cagejohn%';