Tags and Searching on PlanetMySQL

Well, let me cut right to the chase. You can finally search the archives of PlanetMySQL. Yes, just go to the sidebar, enter your query and off you go. Yes, it is using a MySQL fulltext search index, and why not, we are MySQL after all ;) The search is happening in Boolean Mode so all the operators and expectations for doing such a search will help you find whatever you are looking for.

But Wait...! There's a bit more than that.

You might notice under each post title there's a new row of words.

We've been importing the tags you place on your posts for years, we just never did anything with them. So what can you do?

\* You can see how people tagged their posts
\* You can click on a tag and see all the similar tags across PlanetMySQL
\* If you are logged in, you may also EDIT the tags and make them relevant
\* You can also search for multiple tags.

So each one in turn:

1. Looking at a tag across PlanetMySQL.

Simply click on the tag. That's it. Now tags are case INsensitive so "MySQL" will translate to the same tag as "mysql" and "mYsQl". If you tag your posts on your blog and our SimplePie aggregator understands how it is tagged it will do it's very best to place it all correctly.

2. Editing Tags


This will \*only\* work if you are logged in to PlanetMySQL with a MySQL.com account. You can click on the "(edit)" link which opens up an input box, enter your tags as comma delimited words and hit "go". That's it. If you need to remove and existing tag, remove the word and click "go".



3. Searching for multiple tags

Well, this may be considered a bit of a hack :) In the search box, you can type in a query such as the following:

"Tags: mysql, open source"

It will attempt to find those tags, intersect them and bring back those posts which are tagged with "MySQL" AND "Open Source". You can try any number of tags to narrow the search.



Because I kept mistyping when I was testing, you can also do:

"Tag: mysql, open source"

Now what happens when no tags are matched? Such as with "Tags: nonexistent", well, "Tags:" will be stripped and a regular fulltext search on "nonexistent" will be attempted.

For those who have been waiting for searching of \*any\* type on PlanetMySQL, here you go, sorry about the delay.

Comments, feedbacks, bugs, cupcakes are always welcome. We hope both these changes are non-intrusive and add value to the PlanetMySQL community. 

Comments:

Well done Dups!
Just to prove the concept, I added a "Dups is great" tag to this post :)

Giuseppe

Posted by Giuseppe Maxia on June 04, 2009 at 03:11 AM EDT #

Fab to finally have a search!
The tags were of course already in there, just not displayed eh?
Re those tags, why allow editing?

Posted by Arjen Lentz on June 04, 2009 at 12:47 PM EDT #

Arjen: It is so that the power of the community can improve upon the tagging of content so that people can help improve the value of everyone's content and ability to find things! Plus lots of people don't tag, and now you can go help everyone out. It is, as always, about the power of our wonderful community, don't you agree?

Posted by Dups on June 04, 2009 at 05:46 PM EDT #

Dups: job well done!

Shlomi

Posted by Shlomi Noach on June 06, 2009 at 06:50 PM EDT #

Nice work. 'Tags:rant' finds a few posts. 'Tags:fud' finds none. I think that might change soon.

Posted by Mark Callaghan on June 09, 2009 at 07:45 AM EDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

This is the blog of Dups... currently I'm one of MySQL's Community Relations Managers for Sun Microsystems, post, contact me, I want to hear from you!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today