-1

I want to remove all text before the "@"
in table "food", column "names"

For example:

123@apple
890@orange

so the result will be just

apple
orange

Any help is appreciated

theor
  • 1
  • 1

1 Answers1

0

I am assuming you are trying to update a particular column in some table of a database.
You may try this to replace a substring in a column for each record

Community
  • 1
  • 1
Vikram Patil
  • 152
  • 2
  • 11
  • I didn't find a solution in the link provided. all the text I want to remove in each row is different. – theor Jan 08 '17 at 09:26