Hi
Try this.
select * from table where upper(text) like upper('%dog%')
Then all words with 'dog' in it, will appears in your query.
Hope this helps....
/Frank
>
> 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
---------------------------------------------------------------------
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
