I have a database with thousands of lines of products in it. The data in a particular row has become somehow merged with data from a second table and it should not be that way. These are book titles, and the series in which the books are assigned has been added. They are separated by a slash.
"Batman" reads like this:
"Batman / League of Justice Friends"
"Strawberry Shortcake" reads like this:
"Strawberry Shortcake / Early Readers K-3"
What I need to do is run a regular expressions in the sql dump, that will remove the "/" in the product title and everything after the slash, leaving just the book title.
Thanks in advance for any assistance.