How I can try AND in Laravel Query Builder ?

I want to query like the following

SELECT * FROM Table
WHERE Column='Value'
AND NewColumn='Value'

I don't know how to query AND in Laravel Query Builder. Can someone help me?

Best Answer

Level 4

Just append a new where(...) to your query. It will autmatically be AND.

Table::where('Column', Value)->where('NewColumn', Value)->get();

More details are available in the docs here.

7 likes

Level 1

i try it, i take union of where not merge of them

Please or to participate in this conversation.