REGXP include exclude
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 ?
Subject
Written By
Posted
REGXP include exclude
April 06, 2012 05:33AM
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.