Need Small SQL Query to search the multiple tags from multiple Columns in the SQL Table.

Need proper SQL Query for the following query: For E.g. there are some records in the SQL DB Table as follows: ID NAME DESCRIPTION 1 Test One This is the Test Record having test description 2 2nd Record This test record is the another one with sample text When you are typing in words to search for an item and you hit return each time. Examples “test” “record” “text” The search conducted should only be looking for items that match all three of the criteria and not just one of the criteria. Otherwise we are getting bad results, especially when you search like “test” “text”. It is giving us lots of items with just 'test', but are not related to 'text'. Need SQL Query for the above.