the DataAssist search behavior should be applied to the Results page, make sure you are not applying the search behavior to the search page.
To create a search criteria that will search more than one database column from a single search input box,, change the search type from value to Keyword. This will allow you to select multiple columns to search.