简单更新查询不起作用 - MySQL

Question

Here is my Update Query in Laravel

$do = DB::table('pipo_orders')
            ->where('id', 1)
            ->update(array('clientcopyimage' => 1));

The Table name is pipo_orders while i execute the query no change is happening to that particular coloumn.

Is there any basic mistake in the Query

Here is the Documentation i followed.

Answer 1

As you said the datatype for clientcopyimage is varchar, then you should quote your value like Girish said

$do = DB::table('pipo_orders')
            ->where('id', 1)
            ->update(array('clientcopyimage' => "1"));