Mailing List Archive


Back to the month index Back to the list index
bob basques (bob.basques@stpaul.gov)
Sun, 26 Jan 1997 20:41:48 -0600 

Message-Id: <32EC15EC.4F12@stpaul.gov>
Date: Sun, 26 Jan 1997 20:41:48 -0600
From: bob basques <bob.basques@stpaul.gov>
Subject: Re: [mSQL] Searching all fields at a time

Marcos Manhaes Marins wrote:
>
> <! msql if ($field == "")>
> <! msql query "select CODE,STILL,TITLE from bmdb where TITLE like
> '%$keyword%' $mode TITLE like '%$keyword2%' or BASED like '%$keyword%' or
> DIRECTOR like '%$keyword%' or CAST like '%$keyword%' or SCRIPT like
> '%$keyword%' or PRODUCER like '%$keyword%' or PHOTOGRAPHY like '%$keyword%'
> or ART like '%$keyword%' or SOUND like '%$keyword%' or EDITION like
> '%$keyword%' or MUSIC like '%$keyword%' or CREW like '%$keyword%' or
> STORYLINE like '%$keyword%' or AWARDS like '%$keyword%' LIMIT 5" q>
>
> Hi everybody,
>
> How can we make a search in ALL the fields without specifying EACH SELECT in
> the way I did (it is working but it is too long) above?
>
> In fact I have 30 fields, but to keep the length short I preferred to
> specify just a few. Is there a command SELECT * from footable where * like
> '%$keyword%' ?
>
> Cheers,
>
> Marcos

Try this:

SELECT * from footable

It works from the command line with MSQL

bobb 

-- 
Bob Basques
bob.basques@stpaul.gov - WORK
 blammo@win.bright.net - HOME
        www.stpaul.gov - 3rd of a bunch of (Volunteer) Webmasters 
    bridges.stpaul.gov - Webmaster
25 W. 4th St.            PHONE (612)266-6188
900 C.H.A. Bridge Div.     FAX (612)292-6315
St. Paul, Mn. 55102
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!