On laravel using builder query whereRaw ?&

Question

I have problem using query whereraw on laravel 5.5 postgresql, for this case i want to select data by colors. Data example Source postgresql documentation postgres. I'm success to try on execute sql like this success example execute query. But fail using laravel example source code. Error on laravel

Answer 1

The problem is that your statement contains a question mark. When using the whereRaw method, the question mark is an expected parameter, which aren't providing in your call.

However it seems that there isn't a real solution for this issue. I suggest you take a look at Question mark operator in query, it handles about a similar issue.