The new InnoDB full-text search feature in MySQL 5.6 helps in this case. I use the following query: SELECT MATCH(column) AGAINST(‘(word1* word2*) (“word1 word1”)’ IN BOOLEAN MODE) score, id, column FROM table having score>0 ORDER BY score DESC limit 10; where ( ) groups words into a subexpression. The first group has like word% meaning; … Read more
Full text search is likely to be quicker since it will benefit from an index of words that it will use to look up the records, whereas using LIKE is going to need to full table scan. In some cases LIKE will more accurate since LIKE “%The%” AND LIKE “%Matrix” will pick out “The Matrix” … Read more
Enclose the keywords in double quotes if you want to search exactly for control of SET @Keywords=””control of”” If you want to search for control and of, use the following: SET @Keywords=”control AND of” But server may consider of as a garbage or stop word, so in this case use the following: SET @Keywords=”control AND … Read more
thinking_sphinx and sphinx work beautifully, no indexing, query, install problems ever (5 or 6 install, including production slicehost ) why doesn’t everybody use sphinx, like, say craigslist? read here about its limitations (year and a half old articles. The sphinx developer, Aksyonoff, is working on these and he’s putting in features and reliability and stamping … Read more
The previously highest rated answer is deprecated. As of Django 1.10 there is no more search field lookup for MySQL databases (see the search section in the 1.10 documentation). The release notes for 1.10 also propose a solution to this, by defining a custom lookup: ###__search query lookup The search lookup, which supports MySQL only … Read more
Check out Sunspot for Solr http://github.com/outoftime/sunspot
The highlighting is called Text Fragments. Its a new feature that was recently added to Chrome 80. It works by specifying a text snippet in the URL hash. Yes it is browser specific. No, the experience that you get when clicking on a link from Google’s search results is part of Featured Snippets which are … Read more
The function you have defined above uses Entity SQL, not Transact SQL, so I think the first step is to figure out whether CONTAINS(*,’text’) can be expressed in Entity SQL. Entity SQL doesn’t support the * operator as described here: http://msdn.microsoft.com/en-us/library/bb738573.aspx and if I try entities.CreateQuery<TABLE_NAME>(“select value t from TABLE_NAME as t where CONTAINS(*, ‘text’)”); … Read more
Full text search is good for finding words, not substrings. For substring searches you’d better use like ‘%don%’ with pg_trgm extension available from PostgreSQL 9.1 and using gin (column_name gin_trgm_ops) or using gist (column_name gist_trgm_ops) indexes. But your index would be very big (even several times bigger than your table) and write performance not very … Read more
I’m not sure I quite understand the question but if you want to search objects on the database for a particular search string try: SELECT owner, name, type, line, text FROM dba_source WHERE instr(UPPER(text), UPPER(:srch_str)) > 0; From there if you need any more info you can just look up the object / line number. … Read more