Hey everyone,
So, I've built a very simple search program that, using PHP on a webpage, takes a value and runs it through an SQL query of a database (currently on localhost). The search works fine, but I'm looking for some way to make it a tad less specific.
For example, the table it's searching contains food names. If the user types in "Tea" and the system looks, it will only return "Tea", rather than "Green Tea'". The reverse is also true.
I was wondering if there is a simple manner in which to expand that. If so, I'd appreciate knowing so. Thanks in advance to any who might answer.
So, I've built a very simple search program that, using PHP on a webpage, takes a value and runs it through an SQL query of a database (currently on localhost). The search works fine, but I'm looking for some way to make it a tad less specific.
For example, the table it's searching contains food names. If the user types in "Tea" and the system looks, it will only return "Tea", rather than "Green Tea'". The reverse is also true.
I was wondering if there is a simple manner in which to expand that. If so, I'd appreciate knowing so. Thanks in advance to any who might answer.