Databases
StackOverflow2013
Postsdbo
 
Search
scanning

Scanning is the default search option for small tables.

Enter text here to perform a scan over supported column types.

Text columns with limited length use a substring search If the entered text is a number, integer columns will be scanned for an exact match of the value.

The scanning search option is disabled for large tables.

seeking

Seeking is the default search option for large tables.

Seeking requires indexes and can only be done using the column (or columns) the index is defined on.

In the single-column case, the database will seek to the position the entered search term would be at and return all rows greater or equal to that value.

In the multiple-column case, the above still applies to the column you supplied non-empty search text for. All previous columns, however, will be using an equality match.

Id
AcceptedAnswerId
CreationDate
FavoriteCountLastActivityDate
LastActivityDate
LastEditDate
LastEditorUserIdLastEditDate
ParentIdCreationDate
OwnerUserIdCreationDate
PostTypeIdCreationDate
ScoreLastEditDate
Title
ViewCountLastEditDate
› search options
 
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to undo the most recent commits in Git?
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTon van den Heuvel
    1. USHamza Yerlikaya
  2. POHow do I delete a Git branch both locally and remotely?
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USMatthew Rankin
  3. POHow do I convert a String to an int in Java?
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPeter Mortensen
    1. USUnknown user
  4. POHow do I redirect to another webpage?
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPeter Mortensen
    1. USvenkatachalam
  5. POHow to check whether a string contains a substring in JavaScript?
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKos
    1. USgramm
  6. POHow do I remove a particular element from an array in JavaScript?
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USWalker
  7. POHow do I find all files containing specific text on Linux?
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPeter Mortensen
    1. USNathan
  8. POHow to create an HTML button that acts like a link?
    primarykey
    data
    text
    <p>I would like to create an HTML button that acts like a link. So, when you click the button, it redirects to a page. I would like it to be as accessible as possible.</p> <p>I would also like it so there aren't any extra characters, or parameters in the URL.</p> <p>How can I achieve this?</p> <hr> <p>Based on the answers posted so far, I am currently doing this:</p> <pre><code>&lt;form method="get" action="/page2"&gt; &lt;button type="submit"&gt;Continue&lt;/button&gt; &lt;/form&gt; </code></pre> <p>but the problem with this is that in <a href="http://en.wikipedia.org/wiki/Safari_%28web_browser%29" rel="noreferrer">Safari</a> and <a href="http://en.wikipedia.org/wiki/Internet_Explorer" rel="noreferrer">Internet&nbsp;Explorer</a>, it adds a question mark character to the end of the URL. I need to find a solution that doesn't add any characters to the end of the URL.</p> <p>There are two other solutions to do this: Using JavaScript or styling a link to look like a button.</p> <p>Using JavaScript:</p> <pre><code>&lt;button onclick="window.location.href='/page2'"&gt;Continue&lt;/button&gt; </code></pre> <p>But this obviously requires JavaScript, and for that reason it is less accessible to screen readers. The point of a link is to go to another page. So trying to make a button act like a link is the wrong solution. My suggestion is that you should use a link and <a href="https://stackoverflow.com/questions/710089/how-do-i-make-an-html-link-look-like-a-button">style it to look like a button</a>.</p> <pre><code>&lt;a href="/link/to/page2"&gt;Continue&lt;/a&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USAndrew
  9. POHow to revert a Git repository to a previous commit
    primarykey
    data
    text
    <p>How do I revert from my current state to a snapshot made on a certain commit?</p> <p>If I do <code>git log</code>, then I get the following output:</p> <pre><code>$ git log commit a867b4af366350be2e7c21b8de9cc6504678a61b` Author: Me &lt;me@me.com&gt; Date: Thu Nov 4 18:59:41 2010 -0400 blah blah blah... commit 25eee4caef46ae64aa08e8ab3f988bc917ee1ce4 Author: Me &lt;me@me.com&gt; Date: Thu Nov 4 05:13:39 2010 -0400 more blah blah blah... commit 0766c053c0ea2035e90f504928f8df3c9363b8bd Author: Me &lt;me@me.com&gt; Date: Thu Nov 4 00:55:06 2010 -0400 And yet more blah blah... commit 0d1d7fc32e5a947fbd92ee598033d85bfc445a50 Author: Me &lt;me@me.com&gt; Date: Wed Nov 3 23:56:08 2010 -0400 Yep, more blah blah. </code></pre> <p>How do revert to the commit from November 3, i.e. commit <code>0d1d7fc</code>?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPeter Mortensen
    1. USCrazy Serb
...and more
 

Querying!

 
Guidance
A table list

Lists show table rows with slightly less information than detail views, therefore not requiring section labels.

This list shows the beginning of an entire table.

Search

Searching on lists works via indexes when the table is large. On the left you see input fields generated from viable indexes and an expandable report for all indexes that are unavailable for searching with the respective reasons.

Searching along indexes is called seeking and this is one of the main values that databases offer. The trivial alternative is scanning, which is potentially inefficient as it works by walking the entirety of the candidate rows to find the matches.

The offer to scan is given for small tables. Currently, this only works on text and integer columns and they are searched all at once.

Loading more

Loading more rows than the initial 10 results is also currently restricted to a single reloading of 100 entries.

A future version will keep auto-loading on scroll for tables that have suitable indexes.

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