How to search across multiple fields in a table?

Question

SQL

There is a table containing a bunch of fields, including a dozen text fields.
Is it possible to build a query in such a way that it searches for a specific word in all text fields? For example "test".
Of course, you can spawn a bunch of LIKEs. Or write a script (I work in php) that will generate all these likes so as not to write manually. But I wonder if it is possible to do it beautifully using SQL? And if possible, I would like to see an example :)

Answer 1

you can add (text string concatenation) all columns and search as a result of addition - there will be less LIKEs and ORs

Answer 2

It is possible to make through the data dictionary the truth already by means of Transact-SQL.
https://professorweb.ru/my/sql-server/2012/level3/...