List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 17 1999 8:55pm
Subject:Re: Substring SELECTs
View as plain text  
At 1:45 PM -0700 8/17/99, Richard Whittaker wrote:
>Greetings all:
>I'll admit it, my brain must be mushy, but for the life of me I can't see
>or figure out what to do to get a substing select to work, for example:
>User enters a the string "blah" to do a search..
>The behaviour I'm looking for is to have anything within selected column
>that has the string "blah" in it to be marked and retreived... Is this as
>simple as I think it should be?...

Is this what you want?

SELECT ... WHERE col_name LIKE "%blah%"

Paul DuBois, paul@stripped
Substring SELECTsRichard Whittaker17 Aug
  • Re: Substring SELECTsPaul DuBois17 Aug
  • Re: Substring SELECTsaaron abelard17 Aug
  • Re: Substring SELECTsChristian Mack8 Sep