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?