how to retrive custom data from database from specific column in laravel php

Question

I have a table users in database

id, name, users_type

there are multiple types of users_type like Admin, Sub Admin, Unsigned, Normal User

I want to get All Types of users_type But Not Admin user.

have you tried doing sql directly to the database? just sql query. without eloquent or any. — Charis
– Charis, Commented Jun 22, 2018 at 4:24

rkj · Accepted Answer · 2018-06-22 04:41:27Z

1

If you are using eloquent Model then

$users = User::where('users_type', '!=', 'Admin')->get();

Using Query Builder

$users = DB::table('users')->where('users_type', '!=', 'Admin')->get();

answered Jun 22, 2018 at 4:29

rkj

8,3172 gold badges30 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DsRaj · Accepted Answer · 2018-06-22 04:36:45Z

0

$users = User::where('users_type','<>','Admin')->get();

You want to get result for equals to then no need add =

If you want to get only one user then use first() insted of get()

answered Jun 22, 2018 at 4:36

DsRaj

2,3181 gold badge19 silver badges27 bronze badges