get text after some symbol in mysql

Question

I need mysql query which brings the text after (e) symbol

eg. I have the following text in mysql table

test of my application (e) I'm so happy

after run query I need as a result I'm so happy

Check out [substring_index](http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_substring-index). — Vatev, May 27 '14 at 19:55
Possible duplicate: http://stackoverflow.com/questions/2696884/mysql-split-value-from-one-field-to-two — sgeddes, May 27 '14 at 19:57

score 1 · Accepted Answer · edited May 27 '14 at 20:26

1

It should be fairly easy with substring_index()

SELECT SUBSTRING_INDEX(`column_name`, ')', -1) // return everything from the right of the closing parentheses

edited May 27 '14 at 20:26

Funk Forty Niner

answered May 27 '14 at 19:59

Jay Blanchard

1 Answers1