StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18322966
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-08-19T20:55:53.837
FavoriteCount
0
LastActivityDate
2013-08-20T07:32:32.803
LastEditDate
2013-08-20T07:32:32.803
LastEditorUserId
331637
OwnerUserId
331637
ParentId
9546114
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
The current answer does work for the example that the OP has given, but it doesn't really answer the question. The OP asks for a query that orders by the most common characters, but the query only works if the DB entry contains a subset of the characters in the search query, and nothing more. For example, comparing name111someignorechar with name1otherignorechar wouldn't work. There's another solution, as explained here: <a href="http://tech-q-a.tumblr.com/post/58713827644/how-to-sort-results-based-on-the-number-of-identical" rel="nofollow">http://tech-q-a.tumblr.com/post/58713827644/how-to-sort-results-based-on-the-number-of-identical</a> We can use a MySQL function that counts the number identical starting-characters for two strings: <pre><code>DROP FUNCTION IF EXISTS countMatchingBeginChars; delimiter // CREATE FUNCTION `countMatchingBeginChars`( s1 text, s2 text ) RETURNS int(11) DETERMINISTIC BEGIN DECLARE s1_len, s2_len, min_len, j INT; SET s1_len = LENGTH(s1), s2_len = LENGTH(s2); IF s1_len > s2_len THEN SET min_len = s2_len; ELSE SET min_len = s1_len; END IF; SET j = 0; WHILE j <= min_len DO SET j = j + 1; IF SUBSTRING(s1,j,1) != SUBSTRING(s2,j,1) THEN RETURN j-1; END IF; END WHILE; RETURN min_len; END// delimiter ; </code></pre> So, <pre><code>SELECT countMatchingBeginChars("name111someignorechar", "name11") </code></pre> would return 6 (as above), but so would <pre><code>SELECT countMatchingBeginChars("name111someignorechar", "name11otherignore") </code></pre> Now, we can sort the entries in the database according to the number of matching characters: <pre><code>SELECT name FROM names ORDER BY countMatchingBeginChars("name111someignorechar",name) DESC, name </code></pre> If only the entry with the most matching characters is required, we can just return only one result. <pre><code>SELECT name FROM names ORDER BY countMatchingBeginChars("name111someignorechar",name) DESC, name LIMIT 1 </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POMysql: find string with most matching starting characters
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USTinkerTank
UserOwnerUserId
1. USTinkerTank
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.