Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: Is DBman SQL capable of searching field?

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