|
|
Posted by Stefan Rybacki on 04/15/06 06:17
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
kristian schrieb:
> not quite, although it fits the '*apples' problem.
>
> But if I enter a search phrase like 'php5 mysql' it dosnt match
> anything. If I use select title, description from sometable
> where match (title,description) against ('$word' in boolean mode) I
> can add '$word*' and I will get results where $word is at the
> beginning, what I want is also to have results where $word is at the
> end.
>
Unfortunately this is not supported by the nature of how mysql fulltext
index works.
What you can do is some tricky stuff like having your text also in a
mirrored version like "drow" and also an index on it. That way you could
also find words ending on "word" by doing a search against
'str_reverse($word)*'.
This was just a thought out of the blue and since I don't know your
entire design and stuff it fits or it doesn't.
Regards
Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.1 (MingW32)
iD8DBQFEQGXIyeCLzp/JKjARApGCAKCAAUTJWnsyKuIejtzg4t6X1T/Y1QCfaLLS
nskbus9X3jIfa/tVooe7SPk=
=Lu7u
-----END PGP SIGNATURE-----
Navigation:
[Reply to this message]
|