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
Subject Author Views Date
Thread Is DBman SQL capable of searching field? santana 1344 Nov 18, 2000, 12:59 AM
Thread Re: Is DBman SQL capable of searching field?
Bearwithme 1272 Nov 21, 2000, 4:04 AM
Post Re: Is DBman SQL capable of searching field?
santana 1271 Nov 21, 2000, 6:17 AM