sql search keyword

Article View: bit.databases.mssql-l

Article #207

Back to bit.databases.mssql-l Previous Next

#207

From: exist_world_beyond_yours
Date: Mon, 24 Feb 2003 18:34

16 lines
1605 bytes

Hello,  I'm trying to search for particular  word inside  VARCHAR (not
entire phrase)   but


WHERE
   CIRCUIT.TABLE.NAME LIKE :keyword

only work for the entire phrase.  Ex.  " i go to java class" , search key
want to be consider match "java"

How do I code it in java?

   ResultSet results = statement.executeQuery("SELECT * FROM CIRCUIT.TABLE
WHERE CIRCUIT.TABLE.NAME LIKE *"+keywordz+"*");  /* doesn't work */

Thank you for reviewing

Technical Details

Message-ID: <3e5a621d_1@news.tm.net.my>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newshosting.com!news-xfer2.atl.newshosting.com!uunet!dca.uu.net!ash.uu.net!news1.tm.net.my

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5d71,e6cac314263c9233,start
X-Google-Attributes: gidf5d71,public
X-Google-Thread: 10f47b,e6cac314263c9233,start
X-Google-Attributes: gid10f47b,public
X-Google-Thread: f6611,e6cac314263c9233,start
X-Google-Attributes: gidf6611,public
X-Google-ArrivalTime: 2003-02-24 10:27:24 PST
From: "exist_world_beyond_yours" <donT@email_back.pls.com>
Newsgroups: bit.databases.mssql-l,comp.databases.ibm-db2,comp.lang.java
Subject: sql search keyword
Date: Tue, 25 Feb 2003 02:34:20 +0800
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 219.94.102.99
X-Original-NNTP-Posting-Host: 219.94.102.99
Message-ID: <3e5a621d_1@news.tm.net.my>
X-Trace: news.tm.net.my 1046110749 219.94.102.99 (25 Feb 2003 02:19:09 +0800)
Organization: TMnet Malaysia
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newshosting.com!news-xfer2.atl.newshosting.com!uunet!dca.uu.net!ash.uu.net!news1.tm.net.my