List:General Discussion« Previous MessageNext Message »
From:Faisal Nasim Date:July 25 1999 11:25am
Subject:Re: Number of matches
View as plain text  
: Faisal Nasim writes:
:  > Hi,
:  > 
:  > How do I search for a particular word in ANY field?
:  > 
:  > And also get the number of matches of the search word found? (as a column
:  > perhaps)
:
: Hi!
: 
: The answer is : one by one ! It can be done in a single query, though.
: 
: Sinisa

select * from mytable where ANY_FIELD LIKE 'BLAH';

Do I have to put all the fields like

blah like 'BLAH' OR 'etc' like 'BLAH' and 30 more! :(

?



Thread
Number of matchesFaisal Nasim25 Jul
  • Number of matchessinisa25 Jul
  • Re: Number of matchesFaisal Nasim25 Jul
    • Re: Number of matchessinisa26 Jul
  • PC-Client fksausw25 Jul
    • Jeff Urban25 Jul
    • PC-Client fsinisa26 Jul