I just want to update the status of a booking using bookingid.

```
UPDATE flightbooking
SET status 'C' AS cancelledbooking
FROM flightbooking
WHERE bookingid = 10001;

```

I get the following error:

> 
> ERROR: syntax error at or near "'C'"  
> 
>  LINE 2: SET status 'C' AS cancelledbooking
> 
> 
> 

Any help?