[BNM] Suggest in search - way of doing with MySQL?

[David Pashley]

On Oct 02, 2008 at 11:06, Julian Blundell praised the llamas by saying:
> Hi Paul
> 
> The full text search is pretty clever in MySql, might be worth starting
> there.

Sadly requires MyISAM database storage, so there goes your data
reliability.
> 
> Jules
> 
> 2008/10/2 Paul Silver <paul at tenpastmidnight.com>
> 
> > Hi,
> >
> > I'm making a search within a database driven site soon. We'd like to be
> > able to suggest corrections or just show results for the suggestions if
> > nothing is returned from a straight search.
> >
> > E.g. visitor searches for "bananas in pijamas"
> >
> > Results say: "No results for 'bananas in pijamas', would you like to
> > search for 'banans in pyjamas'"
> >
> > Is there an easy way of doing this with PHP 5 & MySQL 5?
> >
> > Thanks
> >
> > Paul
> >
> >
> > BNM Subscribe/Unsubscribe:
> > http://www.brightonnewmedia.org/options/bnmlist
> >
> > BNM powered by Wessex Networks:
> > http://www.wessexnetworks.com
> >

-- 
David Pashley
david at davidpashley.com
Nihil curo de ista tua stulta superstitione.