You are not logged in.
Victor, what if you change this line:
$search = " and ($cols) $s_filter";
$search = " and (match (`'.join('`, `', $cols)."`) against ('$q')) ".$s_filter;
Does that search case-insensitive… and which MySQL version are you using and what is the collation and charset of your TXP tables and is the db_charset set to utf8 in your config.php?
This really belongs in a separate topic btw, because this is not something that changes in 4.0.7.
Last edited by ruud (2008-11-28 17:41:04)
I think we’ve been there, done that. Wasn’t too performant, IIRC.
That’s a mixed RLIKE / MATCH solution. I was referring to a pure MATCH solution, which should be much faster, but relies completely on MySQL fulltext search for results (which does have some limitations: minimum search word length and skipping words that occur too often)
which does have some limitations: minimum search word length and skipping words that occur too often
I think this is why Alex split the search in two parts. Word length was an annoying issue.