Tags and Searching on PlanetMySQL
By Duleepa Wijayawardhana on Jun 04, 2009
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.