mysql limits you by default to search for strings no smaller than 3 characters, so, if i wanted to look for “dd” in
\ns9y i had no luck.
\nF*n grep is better than mysql with that > 3 chars limit.
\ns9y also uses MATCH and AGAINST which makes searches a bit dumb.
\nTo overcome this i added the parameter “–ft_min_word_len=1” to mysql startup, so we can search strings
\nshorter than 3 chars.
\n\/usr\/bin\/mysqld_safe –ft_min_word_len=1 –datadir=\/var\/lib\/mysql –pid-file=\/var\/run\/mysql\/mysql. pid $SKIP &
\nTo make ft_min_word_len take effect you have to reindex the tables you wish to search with less than 3
\nchars. To do it:
\nmysql> repair table serendipity_entries quick;
\n+———————————+——–+———-+———-+
\n| Table | Op | Msg_type | Msg_text |
\n+———————————+——–+———-+———-+
\n| serendipity.serendipity_entries | repair | status | OK |
\n+———————————+——–+———-+———-+
\n1 row in set (0.20 sec)
\nmysql> repair table serendipity_authors quick;
\n+———————————+——–+———-+———-+
\n| Table | Op | Msg_type | Msg_text |
\n+———————————+——–+———-+———-+
\n| serendipity.serendipity_authors | repair | status | OK |
\n+———————————+——–+———-+———-+
\n1 row in set (0.00 sec)
\nmysql> repair table serendipity_entrycat quick;
\n+———————————-+——–+———-+———-+
\n| Table | Op | Msg_type | Msg_text |
\n+———————————-+——–+———-+———-+
\n| serendipity.serendipity_entrycat | repair | status | OK |
\n+———————————-+——–+———-+———-+
\naround line 773 of s9y include\/functions_entries.inc.php we changed MATCH and AGAINST for LIKE
\n\/\/– rdircio, better searches here
\n\/\/ $cond[‘find_part’] = “MATCH(title,body,extended) AGAINST(‘$term’ IN BOOLEAN MODE)”;
\n50\/433
\n$cond[‘find_part’] = “(title LIKE ‘%$term%’ OR body LIKE ‘%$term%’ OR extended LIKE
\n‘%$term%’)”;
\n} else {
\n\/\/ $cond[‘find_part’] = “MATCH(title,body,extended) AGAINST(‘$term’) “;
\n$cond[‘find_part’] = “(title LIKE ‘%$term%’ OR body LIKE ‘%$term%’ OR extended LIKE
\n‘%$term%’)”;
\n}
\nNow, you can enter text in the quicksearch like ” tar c ” at this blog and it will find entries like ” tar cvf” and not
\nentries like “start”
\n51\/433<\/p>\n","protected":false},"excerpt":{"rendered":"
mysql limits you by default to search for strings no smaller than 3 characters, so, if i wanted to look for “dd” in s9y i had no luck. F*n grep is better than mysql with that > 3 chars limit. s9y also uses MATCH and AGAINST which makes searches a bit dumb. To overcome this […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-445","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts\/445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=445"}],"version-history":[{"count":0,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/posts\/445\/revisions"}],"wp:attachment":[{"href":"\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=445"},{"taxonomy":"post_tag","embeddable":true,"href":"\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}