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 2293 Nov 18, 2000, 12:59 AM
Thread Re: Is DBman SQL capable of searching field?
Bearwithme 2176 Nov 21, 2000, 4:04 AM
Post Re: Is DBman SQL capable of searching field?
santana 2172 Nov 21, 2000, 6:17 AM