StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
6464163
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-06-24T06:18:43.587
FavoriteCount
0
LastActivityDate
2011-06-24T06:18:43.587
LastEditDate
LastEditorUserId
0
OwnerUserId
247090
ParentId
6463922
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Firstly there are some online sites that can help you to develop a regular expression. They let you enter some text, and a regular expression and then show you the result of applying the expression to the text. This saves you having to write code as you develop the expression and expand your understanding. A good site I use alot is <a href="http://www.fileformat.info/tool/regex.htm" rel="nofollow">FileFormat regex</a> because it allows me to test one expression against multiple test strings. A quick search also brought up <a href="http://www.regexplanet.com/simple/" rel="nofollow">regex Planet</a>, <a href="http://gskinner.com/RegExr/" rel="nofollow">RegExr</a> and <a href="http://regexpal.com/" rel="nofollow">RegexPal</a>. There are lots of others. In terms of resources, the <a href="http://download.oracle.com/javase/6/docs/api/" rel="nofollow">Java Pattern class reference</a> is useful for Java development and I quite like <a href="http://www.regular-expressions.info/" rel="nofollow">regular-expression.info</a> as well. For your problem I used fileFormat.info and came up with this regex to match "http://whatismyipaddress.com/ip/1.1.1.1": <pre><code>.*//([.\w]+)/.*/(\d+(?:.\d+){3}) </code></pre> or as a java string: <pre><code>".*//([.\\w]+)/.*/(\\d+(?:.\\d+){3})" </code></pre> A quick break down says anything (<code>.*</code>), followed by two slashes (<code>//</code>), followed by at least one or more decimal points or characters (<code>([.\w]+)</code>), followed by a slash, any number of characters and another slash (<code>/.*/</code>), followed by at least 1 digit (<code>(\d+</code>), followed by 3 sets of a decimal point and at least one digit (<code>(?:.\d+){3})</code>). The sets of brackets around the server name part and the IP part are called capturing groups and you can use methods on the Java Matcher class to return the contents of these sections. The <code>?:</code> on the second part of the ip address tells it that we are using the brackets to group the characters but it's not to be treated as a capturing group. This regex is not as strict or as flexible as it should be, but it's a starting point. All of this can be researched on the above links.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPossible Regular Expression Question
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USdrekka
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.