Re: Number of matches

[Faisal Nasim]

: 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! :(

?