I’m probably being lazy here as I’m sure I can find the same results on Google, but I wonder if anybody could point me in the right direction of how to perform fulltext keyword searches, a la krop.com.
At a guess, I imagine the entered string is split at the spaces to make an array of keywords, then that array is used to create multiple OR LIKE ‘%array_value%’ statements.
Is this really the most efficient method? I can imagine it gets especially intensive when you need to fire a query every keystroke (even though I will cache using the usual CI way).
Any points would be appreciated.