Search
Search

Select specific columns with a condition in Laravel

REZAZI MOHAMED ABDESSAMED Published at Dev
45
REZAZI MOHAMED ABDESSAMED

lets say that i have user table that has many users in it. I want to get all users but not the auth user. How can i do that in a simple query?, i tried:

$users = User::whereNotIn('id',auth()->user()->id)->get();

But it didn't work. Any help please? and sorry for this simple question.

Pradeep

In and NotIn need an array as second args

$users = User::whereNotIn('id',[auth()->id()])->get();

for more : https://laravel.com/docs/8.x/collections#method-wherenotin

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Select specific columns in pandas DataFrame

Select range of columns by condition in Pandas

How to select specific columns in laravel eloquent

Laravel 5 Eloquent scope join and select specific columns

Intersect Select Statements on Specific Columns

Select only specific columns of CSV

pandas select conditionally specific columns in dataframe with another condition results in concatenation

Select columns that satisfy a condition

Select query for laravel to get specific rows based on a condition at top remaining columns at bottom

How do I select specific columns of a data frame, and sum them based on a condition?

Select specific column value from multiple relational table using where condition in Laravel ORM

How to select columns based on a condition?

sum with a specific condition in select

Laravel select specific columns with Eloquent while eager loading

How to select specific columns from nested relationships in a query with Laravel

Select Specific columns from multiple Table with with() and select ()

Sum Specific Columns for Select Statement

Select specific columns determined by the headers

Python pandas: Select columns where a specific row satisfies a condition

Select the columns based on the condition

Select columns that have a specific type

Query to select limit in specific condition

Joining columns in pandas with specific condition

Select columns in pyrhon based on a condition

Select the count of columns with values with specific name for the columns

Select user id with specific condition

How can i select specific columns that start with a word according to a condition of another column in R using dplyr?

Select specific/all columns in rowwise

rowsums of specific columns filling a condition

TOP Ranking

  1. 1

    pump.io port in URL

  2. 2

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  3. 3

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  4. 4

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  5. 5

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  6. 6

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  7. 7

    ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

  8. 8

    Using Response.Redirect with Friendly URLS in ASP.NET

  9. 9

    Can a 32-bit antivirus program protect you from 64-bit threats

  10. 10

    Double spacing in rmarkdown pdf

  11. 11

    How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?

  12. 12

    3D Touch Peek Swipe Like Mail

  13. 13

    Bootstrap 5 Static Modal Still Closes when I Click Outside

  14. 14

    Assembly definition can't resolve namespaces from external packages

  15. 15

    Vector input in shiny R and then use it

  16. 16

    Emulator wrong screen resolution in Android Studio 1.3

  17. 17

    Svchost high CPU from Microsoft.BingWeather app errors

  18. 18

    Graphics Context misaligned on first paint

  19. 19

    Python connect to firebird docker database

  20. 20

    Is this docker-for-mac password dialog legit?

  21. 21

    How to save models trained locally in Amazon SageMaker?

HotTag

Archive