http://snipplr.com/language/mysql/tags/search Recent snippets posted on Snipplr.com en-us Tue, 21 May 2013 03:12:50 GMT http://snipplr.com/view/60218/update-database-fields-with-search-replace-word/ Used to update a database field using search replace.

]]> Wed, 26 Oct 2011 23:50:44 GMT http://snipplr.com/view/60218/update-database-fields-with-search-replace-word/ http://snipplr.com/view/51513/very-simple-search-retrieval-query-ranking-with-tfidf-weight/ This assumes two tables: `search_results` and `keyword_counts`. `search_results` is an inverted index with, at minimum, fields for the keyword indexed, its occurrences, and the indexed item's id in the table it is in (e.g. `item_id` in `search_results` could be `45`, referencing `id = 45` in `documents`) in the table it's in. `keyword_counts` has a row for each indexed item with the total number of unique words in it and its id in the table the actual item is in. Released into the public domain. This may have bugs in it, but it's worked so far for me.

]]> Mon, 04 Apr 2011 20:33:17 GMT http://snipplr.com/view/51513/very-simple-search-retrieval-query-ranking-with-tfidf-weight/ http://snipplr.com/view/28797/search-and-replace-within-a-field-with-regex-in-mysql/ After a problem with row break in a text field I found this way of searching within a where clause in an SQL query. Can be used for selection or update / replace purposes of course.

]]> Tue, 23 Feb 2010 14:06:08 GMT http://snipplr.com/view/28797/search-and-replace-within-a-field-with-regex-in-mysql/