StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12923070
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-10-16T20:41:37.807
FavoriteCount
0
LastActivityDate
2012-10-16T20:41:37.807
LastEditDate
LastEditorUserId
0
OwnerUserId
1195557
ParentId
12922692
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I will go with MATCH-AGAINST which should be better for MySQL optimized search like search engines. You should view full text searcing: <a href="http://dev.mysql.com/doc/refman/5.5/en//fulltext-search.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.5/en//fulltext-search.html</a> NOTE: in a MySQL table should be INDEX-ed as FULLTEXT of keyword row in a table of database. This would give a greater performance for searching. Example: Example of input keywords: $keywords = '+Word+Word2+Word3'; <pre><code>SELECT p.page_url AS url, COUNT(*) AS occurrences, MATCH('w.word_word') AGAINST ('$keywords') as keyword FROM page p, occurrence o, w.word WHERE MATCH ('w.word_word') AGAINST('{$keywords}' IN BOOLEAN MODE) AND p.page_id = o.page_id AND w.word_id = o.word_id GROUP BY p.page_id ORDER BY occurrences DESC LIMIT $results </code></pre> In other de-optimized mode or risky for slowing performance server if your queries are not opitmized (too many groups, where clauses and conditionals). Instead of this you can use REGULAR EXPRESSION in MySQL for example: <pre><code>REGEXP "/(honda)|(jazz)|(manual)/" </code></pre> This will also get a good performances using regular expressions (not recommended for huge db): Make a loop and count it than put in REGEXP: <pre><code>$keywords = "keyword1,keyword2,keyword3"; $expl = explode("," $keywords); if (count($expl) == 1) { $all = w.word_word REGEXP = '[[:<:]]$keywords[[:>:]]'; } else { $all = ''; foreach ($expl as $keyone) { $all .= 'OR '.w.word_word REGEXP = '[[:<:]]$keyone[[:>:]]'; } } $sql = 'SELECT p.page_url AS url, COUNT(*) AS occurrences FROM page p, word w, occurrence o WHERE p.page_id = o.page_id AND w.word_id = o.word_id AND $all GROUP BY p.page_id ORDER BY occurrences DESC LIMIT $results'; $result_query = mysql_query($sql); </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POmultiple term query
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMarin Sagovac
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. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COYou learn something every day :)
 singulars
 PostPostId
 PO
 UserUserId
 USNikolaos Dimopoulos
2. COYes! Thank you!
 singulars
 PostPostId
 PO
 UserUserId
 USMarin Sagovac

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.