StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>My first reaction would be why you need such an approach, may be you should explain your needs better. But in any case you better look into <code>full text search</code>, just google it.</p> <p>Here are some useful links:</p> <p><a href="http://en.wikipedia.org/wiki/Full_text_search" rel="nofollow">http://en.wikipedia.org/wiki/Full_text_search</a></p> <blockquote> <p>In text retrieval, full text search refers to techniques for searching a single computer-stored document or a collection in a full text database. Full text search is distinguished from searches based on metadata or on parts of the original texts represented in databases (such as titles, abstracts, selected sections or bibliographical references).</p> <p>In a full text search, the search engine examines all of the words in every stored document as it tries to match search criteria (e.g., words supplied by a user). Full text searching techniques became common in online bibliographic databases in the 1990s[verification needed]. Many web sites and application programs (such as word processing software) provide full-text search capabilities. Some web search engines such as AltaVista employ full text search techniques while others index only a portion of the web pages examined by its indexing system.[1]</p> </blockquote> <p><a href="http://msdn.microsoft.com/en-us/library/ms142571.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms142571.aspx</a> Some quotes from the links above: Comparing LIKE to Full-Text Search</p> <blockquote> <p>In contrast to full-text search, the LIKE Transact-SQL predicate works on character patterns only. Also, you cannot use the LIKE predicate to query formatted binary data. Furthermore, a LIKE query against a large amount of unstructured text data is much slower than an equivalent full-text query against the same data. A LIKE query against millions of rows of text data can take minutes to return; whereas a full-text query can take only seconds or less against the same data, depending on the number of rows that are returned.</p> </blockquote>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload