Re: [OT] MySQL full text search

[Ake Hedman <akhe@xxxxxxxxxxxxx>]

Alex,

use something like  field LIKE %xxxxxx%

where xxxxxx is a phrase or something else you are searching for

Separate words and combine with OR/AND to get  more possibilities.

Regards
/Ake

Alex Kinch wrote:

> Anyone here good on MySQL full text search? I'm using it to search
for=20
> a song artist and title within a string and it works sort-of, but
not=20
> brilliantly. The relevency isn't always great. Any suggestions to=20
> improve it with some better pattern matching and/or fuzzy logic
would=20
> be appreciated.
>
> Alex
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> click here=20
> <http://us.ard.yahoo.com/SIG=3D129ntfo0j/M=3D283686.4531047.5839501.44200=
29/D=3Dgroups/S=3D1705041992:HM/EXP=3D1092314455/A=3D2044486/R=3D0/SIG=3D10=
svm8ftb/*http://www.theironshop.com>=20
>
>
>
>
------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
>     * To visit your group on the web, go to:
>       http://groups.yahoo.com/group/ukha_d/
>=20=20=20=20=20=20=20=20
>     * To unsubscribe from this group, send an email to:
>       ukha_d-unsubscribe@xxxxxxx
>       <mailto:ukha_d-unsubscribe@xxxxxxx?subject=3DUnsubscribe>
>=20=20=20=20=20=20=20=20
>     * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>       Service <http://docs.yahoo.com/info/terms/>.
>
>


--=20
---
Ake Hedman (YAP - Yet Another Programmer)
eurosource, Brattbergav=E4gen 17, 820 50 LOS, Sweden
Phone: (46) 657 413430 Cellular: (46) 73 84 84 102
Company home: http://www.eurosource.se=20=20=20=20=20=20
Kryddor/Te/Kaffe: http://www.brattberg.com
Personal homepage: http://www.eurosource.se/akhe
Automated home: http://www.vscp.org



[Non-text portions of this message have been removed]