Article View: borland.public.cppbuilder.database.ado
Article #4113Re: How to write a select statement to search ....
From: Big Stew
Date: Wed, 20 Mar 2002 08:38
Date: Wed, 20 Mar 2002 08:38
19 lines
1447 bytes
1447 bytes
To find all records where "Test it" occurs anywhere in the field Field1 you can use Select * from content where field1 like '%Test it%' BigStew "Daniel Zhou" <langou@gmx.de> wrote in message news:3c980ae5_2@dnews... > Hi, > I want to search a substring in a table. How can I write a select statement > to do it? > For example: > I want to find all record in Table Content where Content.Field1 include the > substring "Test it". > Is it correct: > > Select * from content where "Test it" in field1.
Technical Details
Message-ID:
<3c984a4a_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!cyclone2.usenetserver.com!usenetserver.com!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnewsReferences:
<3c980ae5_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,d18756633b55898c X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-03-20 00:39:20 PST From: "Big Stew" <Big_Stew@talk21.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3c980ae5_2@dnews> Subject: Re: How to write a select statement to search .... Date: Wed, 20 Mar 2002 08:38:59 -0000 Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 212.19.90.97 Message-ID: <3c984a4a_1@dnews> X-Trace: dnews 1016613450 212.19.90.97 (20 Mar 2002 00:37:30 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!cyclone2.usenetserver.com!usenetserver.com!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews