StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17191704
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
9
CommunityOwnedDate
CreationDate
2013-06-19T12:53:01.740
FavoriteCount
0
LastActivityDate
2013-06-19T13:11:52.230
LastEditDate
2013-06-19T13:11:52.230
LastEditorUserId
1093528
OwnerUserId
1093528
ParentId
17191617
PostTypeId
2
Score
5
ViewCount
0
LastEditorDisplayName
text
Body
You need a negative lookbehind here: <pre><code>(?<!\\)\*[^*]+(?<!\\)\* </code></pre> In a Java string, this gives (backslash galore): <pre><code>"(?<!\\\\)\\*[^*]+(?<!\\\\)\\*" </code></pre> Note: the star (<code>*</code>) has no special meaning within a character class, therefore there is no need to escape it Note 2: <code>(?<!...)</code> is a negative lookbehind; it is an anchor, which means it finds a position but consumes no text. Literally, it can be translated as: "find a position where there is no preceding text matching regex <code>...</code>". Other anchors are: <ul> <li><code>^</code>: find a position where there is no available input before (ie, can only match at the beginning of the input);</li> <li><code>$</code>: find a position where there is no available input after (ie, can only match at the end of the input);</li> <li><code>(?=...)</code>: find a position where the following text matches regex <code>...</code> (this is called a positive lookahead);</li> <li><code>(?!...)</code>: find a position where the following text does not match regex <code>...</code> (this is called a negative lookahead);</li> <li><code>(?<=...)</code>: find a position where the preceding text matches regex <code>...</code> (this is a positive lookbehind);</li> <li><code>\<</code>: find a position where the preceding input is either nothing or a character which is not a word character, and the following character is a word character (implementation dependent);</li> <li><code>\></code>: find a position where the following input is either nothing or a character which is not a word character, and the preceding character is a word character (implementation dependent);</li> <li><code>\b</code>: either <code>\<</code> or <code>\></code>.</li> </ul> Note 3: Javascript regexes do not support lookbehinds; neither do they support <code>\<</code> or <code>\></code>. More information <a href="http://regular-expressions.info" rel="nofollow">here</a>. Note 4: with some regex engines, it is possible to alter the meaning of <code>^</code> and <code>$</code> to match positions at the beginning and end of each line instead; in Java, that is <code>Pattern.MULTILINE</code>; in Perl-like regex engines, that is <code>/m</code>.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POFinding a simple pattern in a string unless escaped
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USfge
UserOwnerUserId
1. USfge
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POFinding a simple pattern in a string unless escaped
 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
 VTUpMod
CommentsPostId
1. COMissing ending asterisk: (?<!\\)\*[^*]+\*(?<!\\)
 singulars
 PostPostId
 PO
 UserUserId
 USgreuze
2. CO@greuze oops... Good spotting!
 singulars
 PostPostId
 PO
 UserUserId
 USfge
3. COThanks worked perfectly!!!
 singulars
 PostPostId
 PO
 UserUserId
 USBruce Lowe

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.