MySQL Forums
Forum List  »  Newbie

REGXP include exclude
Posted by: Alby Borroti
Date: April 06, 2012 05:33AM

Hi ,
i have a field that can have this record :

[["GERMAN DENIS ", "IN ALLENAMENTO "], ["FRANCESCO GUIDOLIN", "CONFERENZA STAMPA"], ["ANTONIO DI NATALE", "IN ALLENAMENTO E CONFERENZA STAMPA "]] |

I want to find with a select this record only when the string that i want match are inside the bracket .

For example if i search "GERMAN" and "STAMPA" that record must not appaer but i want only for example when i search "GERMAN" and "ALLENAMENTO" .

Now I use this :
WHERE REGEXP '.*\"[[:graph:][:blank:]]*STRING[[:graph:][:blank:]]*\", \"[[:graph:][:blank:]]*STRING[[:graph:][:blank:]]*\".*' )

But is not the exact i want .

Can You help me ?

Options: ReplyQuote


Subject
Written By
Posted
REGXP include exclude
April 06, 2012 05:33AM
April 06, 2012 04:19PM
April 06, 2012 04:46PM
April 08, 2012 08:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.