So say in my database, i have 5 entries and they are "Black Sheep, White Sheep, Yellow Sheep, Black Bird and Human" (Random examples)
and someone inputs "Sheep" into the text field in the form. I want it to search the database using the keyword "Sheep" so it would bring up the first 3 entries i mentioned above. If they were to enter "Black" it would bring up "Black Sheep" and "Black Bird"
I don't need a full script with how to show the data, just how to search the database using that keyword and then i guess you'd use a while look to show the data
THanks!