Laravel Postgres CAST on integer?

Question

PostgreSQL

$query = Posts::where('owner.name', 'LIKE',  '%' . $text . '%')
                     ->orWhereRaw('CAST(owner.id TEXT) ILIKE "%' . $text . '%"')
                    ->orderBy('owner.id', $order)
                    ->select('posts.*', 'owner.*', )
                    ->leftJoin('users as owner', 'posts.user_id', '=', 'owner.id')
                    ->get();

Gives an error message:

Undefined column: 7 ERROR: column "%2%" does not exist LINE 1: ..._id" =

It seems that such a construction worked before, we use CAST on the field, make it as text and search for the entered text, however, it shows that there is no such table , why?

Answer 1

Because of the double quotes, %2% is treated as a column name. Replace with singles.