Currently searching for multiple words uses OR relation, which is of course useless. The problem here is that mysql either provides a loose search ("bla" matching "blasphemy") or an AND search ("bla" not matching "blasphemy").
There are severaly ways to fix this:
- Several words always use tight mode (not very good because you will miss a lot of results)
- Several words use loose mode for mysql and php for filtering AND wise afterwards (not very performant)
- Some way of advanced syntax like:
- "bla AND pop"
- "bla OR pop"
- "bla* OR pop*"
- "bla* AND pop*"
I am not sure, whether the wildcard thing is too overdone.
Also
filtering search results for different types and status would also be a nice feature.