Multiple where clause, Laravel
Beusebiu
I try to do a query with 2 where clauses, but I get a bad response, not sure why.
$history = AnswerHistory::where('question_id', '=', $id)
->where(function ($query) {
$query->where('answer_type', '!=', "skipped");
})
->get();
For a specific $id in database I have 5 rows, 4 with answer_type = 'skipped, but the 5-one is NULL.
My response is null with this code, if I remove second where I get 5 items that includes "skipped" answers.
Wanted response is 1 row, where answer_type != 'skipped'.
PS. I also tried the answer from here.
Julian S
The Problem is, a varchar that is null is null and not a varchar with a value. So it can not be checked with = or != 'string'. So you have to check if answer_type is != skipped or null
$history = AnswerHistory::where('question_id', '=', $id)
->where(function ($query) {
$query->where('answer_type', '!=', "skipped")
->orWhereNull('answer_type');
})
->get();
この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。
侵害の場合は、連絡してください[email protected]
編集
関連記事
Related 関連記事
- 1
Multiple queries in WHERE clause
- 2
Multiple Case conditions in where clause
- 3
Laravel using where clause on a withCount method
- 4
Apply OR clause in WHERE or HAVING in eloquent laravel
- 5
Laravel Equals Returning Empty In Where Clause
- 6
PDO select multiple table with where clause
- 7
Multiple Where clause in Android SQL statement
- 8
SQL Multiple Joins on same table with where clause
- 9
MySQL JOIN QUERY with MULTIPLE WHERE CLAUSE
- 10
MySQL JOIN QUERY with MULTIPLE WHERE CLAUSE
- 11
Multiple rows in single where ... like clause
- 12
IF in WHERE clause
- 13
InfluxDB - Including multiple values in where clause based on tags
- 14
Join Statement using Query builder with multiple where clause
- 15
Multiple Linked Servers in one select statement with one where clause, possible?
- 16
Laravel: How to use multiple where with Request
- 17
SAS Same column selection multiple times using multiple where clause as different output columns
- 18
Dynamic where clause in lambda
- 19
MINUS vs NOT in where clause
- 20
SQL Ignoring WHERE clause
- 21
Where clause with calculated column
- 22
Using CASE in WHERE clause?
- 23
Conditional WHERE clause using IN
- 24
expdp where clause errors
- 25
Using a %ROWTYPE in a WHERE IN clause
- 26
Where clause with a conditional condition
- 27
Nested decode in where clause
- 28
Query error in WHERE clause
- 29
where clause not working in mysql
コメントを追加