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.