如果字母或单词匹配，MySQL会返回所有内容吗？

Question

This is what I am using right now:

SELECT * FROM title where title.posttitle LIKE '%$Search%'

If someone searches for How to make Apple Pie it returns the right thing.

If someone searches for make Apple Pie it returns nothing for some reason.

How can I make it so if any letter or word matches it returns the record?

Answer 1

If the posttitle contains exactly the $Search value will produce a response. In my point of view searching exactly for a string holding multiple words is not the best practice. I would break the string into words (example using javascript)

var string = "my sample sentence";
var words = str.split(" ");

and then i would search if contains those words

SELECT * FROM title where (title.posttitle LIKE '%words[0]%') AND (title.posttitle LIKE '%words[1]%') ...etc

storing data in one format to your db would also help the search (all lowercase or uppercase)