"Rob" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm having a bit of trouble with a full text search in mysql 3.23.25. I
> have the following table with the following entries:
>
> | id | document_id |document_text
>
> =================================
> | 19 | 1 | Konekta
> | 20 | 2 | Cuentas actualizadas|
> | 21 | 3 | dot contrato servicios Contrato sms
>
> There is a full text index on the document_text column.
>
> When I run the following sql query
>
> SELECT *, MATCH(document_text) AGAINST ('servicios') AS score
> from document_text
>
> I get back a score of zero for all entries.
>
> What am I doing wrong?
Worked like a charm for me.
mysql> SELECT *, MATCH(body) AGAINST ('servicios') AS score from ft;
+----+-------------------------------------+------------------+
| id | body | score |
+----+-------------------------------------+------------------+
| 1 | Konekta | 0 |
| 2 | Cuentas actualizadas| | 0 |
| 3 | dot contrato servicios Contrato sms | 0.50317577871617 |
+----+-------------------------------------+------------------+
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
