Full text search

[Gord Muir]

I'm working on a full text search that will search through subject lines. The search word is not necessarily a discreet word but could be a fragment like ...

dog where dog could appear as hotdog, doggone, dognapper etc.

My question is, is there a way of wildcarding the search request to look for word fragments.

I can see in the MySql manual that a search parameter like dog* will look for any word ending in dog.. but that is not sufficient for this case.

Anyone know to do this, or if it is possible?

Thanks
Gord




_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php