Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Is DBman SQL capable of searching field?

Quote Reply
Is DBman SQL capable of searching field?
in Mysql version, is it possible to search keyword and display only field selected.
For example:
I have 4 fields:
Code:
'Make' | 'Color' | 'Year' | 'Type'
-----------------------------------
Ford | red | 1990 | Taurus
Ford | silver | 1992 | GT
Honda | white | 1999 | Prelude
Toyota | red | 1991 | Celica
Now, I am searching the word: red, and only want to display all Ford model.
Right now, if I am searching the word 'red' then it has 2 records,
Ford-red-1990-Taurus and Toyota-red-1991-Celica

How can we solve this?

Thank you.

__________________________
SantanaBlank
Quote Reply
Re: Is DBman SQL capable of searching field? In reply to
In Reply To:
Now, I am searching the word: red, and only want to display all Ford model. Right now, if I am searching the word 'red' then it has 2 records, Ford-red-1990-Taurus and Toyota-red-1991-Celica
SELECT From your_tablename Make,Color,Year,Type WHERE Color='Red' AND Make='Ford';

HTH

easy does it
Quote Reply
Re: Is DBman SQL capable of searching field? In reply to
I think that was for mySQL query, but how can we apply it into the search form?

Or should make any adjustment into db.cgi?

Thanks so much for any advise

__________________________
SantanaBlank