Hi,
The thing is, if the Outermost quote is single( ' ) , and if you try to use
the same inside the string, in that case you need to go for \'. The same
applies for Double quotes also. Double quotes within the single or single
quote within the double dosen't reqire blackslash.
For instanc
Brent Baisley <[EMAIL PROTECTED]> wrote on 07/01/2005 17:03:36:
> I'm having a lot of trouble trying to get this to work. I've set the
> minimum word length to 2, restarted MySQL and rebuilt the indexes, but
> can't seem to get this to work. Is it because MySQL is not indexing #
> and ++? I can
"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 |
Chris,
I should have added that the explanation is that the full text query does
not automatically sort on the score when boolean mode is selected.
Andy
> -Original Message-
> From: Chris Wilkinson [mailto:[EMAIL PROTECTED]
> Sent: 03 June 2003 13:12
> To: [EMAIL PROTECTED]
> Subject: fu
Chris,
You're nearly there - the way to do it is:
SELECT first_name,last_name,MATCH(first_name,last_name) AGAINST
('+wilkinson* chris*' IN BOOLEAN MODE) AS score FROM names_table WHERE
MATCH(first_name,last_name) AGAINST ('+wilkinson* chris*' IN
BOOLEAN MODE) ORDER BY score DESC;
The db engine w
At 13:11 +0100 6/3/03, Chris Wilkinson wrote:
can anybody explain this to me please! I search am searching
through a database
with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in
case that matters. I created a fulltext search on both fields
together so I can
search the
User ORDER BY First Name
Chris Wilkinson wrote:
can anybody explain this to me please! I search am searching through a database
with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in
case that matters. I created a fulltext search on both fields together so I can
search t
