How can I delete one word from a MySQL database. For example, if I wanted to take a column of store names, and some end with "Inc", what query would remove the "Inc" from "Walmart Inc" for example to just leave it as Walmart? How can I delete one word from a MySQL database