I have a table whereby some ‘website’ fields have been added with the www. and some without.
How can i run a query that will delete all the “www.” rows IF both the “www.” and “non www.” rows are present and match same other fields?
Just as an aside, some (misconfigured?) servers will not process your request without the www prefix being present.
It maybe something to bear in mind before you go assuming the user and/or data-source didn’t know what they’re doing. 