What will be the SQL Query for search function?

Asked Aug 19 '17 at 11:55

Active Aug 19 '17 at 11:57

Viewed 40 times

Let's say, someone search for Android Tricks, now I want to fetch all rows that contain Android and Tricks word. (It does not matter, if they are together or their order).

I saw this article: SQL Like Operator by W3School

But I cannot find anything, that can help me.

What will be the full query?

SELECT * FROM Customers WHERE ???????????

asked Aug 19 '17 at 11:55

Josh Poor

1

You would appear to want a full text search. Start with the documentation: https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html. – Gordon Linoff Aug 19 '17 at 11:56
Row or column? Do you want to search in all columns or in a specific column? – Pred Aug 19 '17 at 11:58
You can also do `column_name LIKE '%Android%' OR column_name LIKE '%Tricks'`. However, the fulltext search would likely be a better solution. – bytepusher Aug 19 '17 at 11:58
Really !! You didn't find anything that can help? watch out this line.. -> `WHERE CustomerName LIKE '%or%' Finds any values that have "or" in any position` – MD Ruhul Amin Aug 19 '17 at 11:59
Column sir @Pred – Josh Poor Aug 19 '17 at 12:00

What will be the SQL Query for search function?

0 Answers0