 |
AppletTalk.com
Java discussions newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Berlin Brown
Guest
|
 Posted: Sat Feb 07, 2004 11:27 pm Post subject: search wildcard clob |
 |
|
General database and jdbc question, lets imagine I have a CLOB and each
clob contains 30-40k worth of data, per record. What techniques can I
use to search through the clob.
Can I do select * from blah where CLOB_FIELD like '%some_text%' or
should I used java routines like reg expression to search through the
text after I receieved a CLOB stream.
for example:
select * from blah where clob_id_field = 1
getstream
if (clob_stream.indexOf('some_text') >= 0)
.....
I am using MySQL jconnector, which would be the fastest?
Berlin Brown
|
|
| Back to top |
|
 |
Berlin Brown
Guest
|
| Posted: Sat Feb 07, 2004 11:53 pm Post subject: Re: search wildcard clob |
|
|
Berlin Brown wrote:
| Quote: | General database and jdbc question, lets imagine I have a CLOB and each
clob contains 30-40k worth of data, per record. What techniques can I
use to search through the clob.
Can I do select * from blah where CLOB_FIELD like '%some_text%' or
should I used java routines like reg expression to search through the
text after I receieved a CLOB stream.
for example:
select * from blah where clob_id_field = 1
getstream
if (clob_stream.indexOf('some_text') >= 0)
....
I am using MySQL jconnector, which would be the fastest?
Berlin Brown
I guess this help, it doesnt do clob, but good enough I guess. |
http://www.devarticles.com/c/a/MySQL/Getting-Started-With-MySQLs-Full-Text-Search-Capabilities/5/
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
