I am using to Search my Queary is using Like Clouse in SQL Query that is finding particular Searched Sentance in the database and response me.
Like Clouse need exact statement in Database then it will response else it will reflect only empty data.
Instead of this, I need on my website when I search for anything it will respond by keyword not sentence.
How can I do it?
- 1 years ago
You can use this query
SELECT * FROM tablename
WHERE column LIKE '%keyword to search%'