How can I make MySQL multiple search words and multiple fields to search correctely
- by newbie
If user inserts search query "john doe new york", then search should find all those words form searched fields, if not all fields are not found, then that row shouldn't be selected at all, only rows that contain all those words should be included in search. How can I do that in MySQL?