First off, from Zend.com this morning, we have a new tutorial that they have posted about using and abusing the MySQL fulltext searching abilities that the newer MySQL versions have.
This tutorial is intended for developers using MySQL (http://www.MySQL.com/) and PHP (http://www.php.net) who want to create a searchable database of some sort of textual data. It will focus on the Full-text capabilities presented by MySQL, moving into the Boolean opportunities that are presented in the latest alpha version, 4.1, of MySQL.
This is a very nice replacement for the traditional "like" idea that so many people start off with. In fact, it's what we use for the results of the Unified Search Engine for each site. When the search is made it matches against the content fields and returns the matches and how relevant those matches are. This article shows you in pretty good detail how to get your search up and running, including using some of the boolean stuff that's only in MySQL 4.1.
Also from Zend, they have the latest PHP Weekly Summary posted. It mentions a few of the larger things that happened this past week, including the 4.2.x scare and update, and some mention of steps they're going to take to see that www.php.net doesn't come to a "grinding halt" like it did this past time when everyone and their dog wanted to upgrade. Thanks to geoff for reminding me of this one.




