0

I have a table with the column 'Customer' as:

select "Customer",
    Count("Customer")
FROM 
   public.master_environmental_data
GROUP BY 
"Customer" :

"BP"            52163
"McDonald's"    8939
"Rexel"         44723
"DTFV"          6404

How can I delete all rows containing "McDonald's"

I tried

Delete
FROM 
   public.master_environmental_data *
WHERE "Customer" = 'McDonald%''%s';

But it does nothing.

How can I account for the apostrophe?

  • Yes. Thank you. Also, why is `%''%` not working which could mean the same right? –  Jul 30 '21 at 00:30

0 Answers0