Question mark in laravel toSQL()

Question

I get this output when trying to use toSQL() to debug my queries.

Laravel code:

$services = Service::latest()->where('status', '=', '0');

Output SQL:

"select * from `services` where `status` = ? order by `created_at` desc"

How can I get a proper query without ? mark? Thanks!

What makes you think, the above is not a "proper query"? – derpirscher Dec 27 '21 at 07:38 — derpirscher, Dec 27 '21 at 07:38

score 1 · Accepted Answer · answered Dec 27 '21 at 07:34

To view the data that will be substituted into the query string you can call the getBindings() function on the query like below.

$query = User::first()->jobs();

dd($query->toSql(), $query->getBindings());

The array of bindings get substituted in the same order the ? appear in the SQL statement.

check this link

1 Answers1