In my Laravel application, I need to check if any of my 20 columns in a table has a specific record. I've searched for this answer, but only found a way to check if it exists in a specific column, but i need to check in all columns, and i was wondering if there's a way to do that without a loop, something like:
DB::table('cart')->where($fileId->id)->exists();
Assuming $field->id is the search term. You can try
//use Illuminate\Support\Facades\Schema;
$columns = Schema::getColumnListing('cart');
$query = DB::table('cart');
$firstColumn = array_shift($columns);
$query->where($firstColumn, $field->id);
foreach($columns as $column) {
$query->orWhere($column, $field->id);
}
$result = $query->exists();