StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5654032
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
7
CommunityOwnedDate
CreationDate
2011-04-13T18:49:08.007
FavoriteCount
0
LastActivityDate
2016-02-29T20:27:17.593
LastEditDate
2016-02-29T20:27:17.593
LastEditorUserId
20394
OwnerUserId
20394
ParentId
5653207
PostTypeId
2
Score
64
ViewCount
0
LastEditorDisplayName
text
Body
<p>The regex <code>//g</code> should work.</p> <p>You're going to kill <a href="http://dev.w3.org/html5/markup/aria/syntax.html#escaping-text-span" rel="noreferrer">escaping text spans</a> in CDATA blocks.</p> <p>E.g.</p> <pre><code><script></script> </code></pre> <p>and literal text in formatted code blocks</p> <pre><code><xmp>I'm demoing HTML </xmp> <textarea></textarea> </code></pre> <p>EDIT:</p> <p>This also won't prevent new comments from being introduced as in</p> <pre><code><!-- not comment text --> </code></pre> <p>which after one round of that regexp would become</p> <pre><code> </code></pre> <p>If this is a problem, you can escape <code><</code> that are not part of a comment or tag (complicated to get right) or you can loop and replace as above until the string settles down.</p> <hr> <p>Here's a regex that will match comments including <a href="http://dev.w3.org/html5/spec-LC/tokenization.html#markup-declaration-open-state" rel="noreferrer">psuedo-comments</a> and unclosed comments per the HTML-5 spec. The CDATA section are only strictly allowed in foreign XML. This suffers the same caveats as above.</p> <pre><code>var COMMENT_PSEUDO_COMMENT_OR_LT_BANG = new RegExp( ')?' + '<!---+>?' // A comment with no body + '|<!(?![dD][oO][cC][tT][yY][pP][eE]|\\[CDATA\\[)[^>]*>?' + '|<[?][^>]*>?', // A pseudo-comment 'g'); </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PORemove HTML comments with Regex, in Javascript
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMike Samuel
UserOwnerUserId
1. USMike Samuel
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. PORemove HTML comments with Regex, in Javascript
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
CommentsPostId
1. COHow would you modify this to get the comments only, and remove the html ?
  singulars
  PostPostId
  PO
  UserUserId
  USguiomie
2. CO@guiomie, I don't understand your goal. Please explain in more detail?
  singulars
  PostPostId
  PO
  UserUserId
  USMike Samuel

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.