How to pass a subquery to a TEXT Query.
507076Apr 22 2008 — edited Apr 22 2008I have this query
SELECT * FROM identity_event
WHERE contains (identityeventdata, '52353465657 inpath(/cid-spf/dest-number)')>0
And I have a table with tons of numbers I need to check for.
Table PHONE_NUMBER
PHONENUM NUMBER
What I want do is something like this.
SELECT * FROM identity_event
WHERE contains (identityeventdata, ' SELECT PHONENUM FROM PHONE_NUMBER inpath(/cid-spf/dest-number)')>0
How can I do that. Is there any trick.
Thx
Naren