[Resolved] How can you take a piece of data and strip some of the info?

[airric]

How can you take a piece of data from a mysql table and take everything after a particluar character and strip out or move it to a new field?

For example:

500 NATIONS-GIFT SET (DVD/4 DISC/1.33/DOLBY 2.0/ENG-FR-SP-SU😎
is in a field in the DB but, I need to strip everything after the right parenthise and save it or at least remove it.

I really hope someone can help me!
Thank you, Airric

[rehfeld]

take a look at strpos() strrpos() and substr()

read the user comments too.

[airric]

Thank you, I got with your help.