使用sql使用一个或多个关键字搜索多个列

I have one search box that I would like to have search 6 columns in my schools database when an input is made. So far the search box searches the name field only and returns a match for exact or partial inputs. I have one search box that I would like to have