Here's what happened - I ftp copied my WordPress files from a sub-directory (named "content") to the root directory. The mysql database still has over 1000 entries using the \content\ as part of its directory structure.
I need to remove \content\ and replace it with \ in the database.
Is there a solution to this by writing a query? How would it be done?