in Mysql version, is it possible to search keyword and display only field selected.
For example:
I have 4 fields:
-----------------------------------
Ford | red | 1990 | Taurus
Ford | silver | 1992 | GT
Honda | white | 1999 | Prelude
Toyota | red | 1991 | CelicaNow, 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
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
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