How to find matches across all columns in a table?

Question

Laravel

Good afternoon! Tell me how to find rows by coincidence from any column?

Here is an example

$users = DB::table('users')
                    ->where('votes', '>', 100)
                    ->orWhere('name', 'John')
                    ->get();

Here we will tell it is necessary to specify columns. Or you can simply not indicate what is needed for all columns.

Answer 1

It is forbidden. And yes, this problem comes up about once in a while.
But you can get the names of all fields with a separate request if you don't want to hardcode them. It's just easier to hardcode.