Thursday Jun 04, 2009

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. 

Thursday May 14, 2009

From Russia with Blogs: PlanetMySQL in Russian

My colleague Lenz might have forgotten to post before he disappeared on a well-deserved vacation but we've enabled Russian as a choice in PlanetMySQL. Feel free to start submitting your Russian language blogs.

Russian Language PlanetMySQL: http://ru.planet.mysql.com
New feed submissions: http://ru.planet.mysql.com/new

We haven't completely translated all the strings yet (that's my fault, I need to stringify the vote stuff) but we're getting there!

(EDIT: LenZ is not on vacation... in fact he is at PHPDay2009 in Verona, Italy... sorry LenZ)

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