Im trying to run a full text query on a two letter keyword 'K7'. I have
set ft_min_word_len=2 and restarted the server and if I view the system
vars in Mysql Workbench it shows it is set correctly.
I have then dropped and re-created the index on the descrip column. It
is an InnoDB
en [mailto:shawn.l.gr...@oracle.com]
>> Sent: Tuesday, July 02, 2013 10:21 AM
>> To: mysql@lists.mysql.com
>> Subject: Re: Full text search and & sign as a part of the keyword
>>
>> Hello,
>>
>> (my response is not top-posted)
>> On 7/2/2013 12:50 PM, l
anged the name of
the test org to "Com&Me".
Searching for "Com", the test org is gonna be listed.
Though, "Com&" no results at
all.
?!?
�
>
>
>
> Hi to all,
>
>
>
> I have this full text search query
>
> SELECT name,
FULLTEXT (at least the MyISAM version) has 3 gotchas:
ft_min_word_len=4, stopwords, and the 50% rule
> -Original Message-
> From: shawn green [mailto:shawn.l.gr...@oracle.com]
> Sent: Tuesday, July 02, 2013 10:21 AM
> To: mysql@lists.mysql.com
> Subject: Re: Full text searc
Searching for "Com", the test org is gonna be listed.
>
> Though, "Com&" no results at
> all.
> ?!?
> �
>>
>
>>
>
>>
>
>> Hi to all,
>
>>
>
>>
>
>>
>
>> I have
the test org to "Com&Me".
Searching for "Com", the test org is gonna be listed.
Though, "Com&" no results at
all.
?!?
�
Hi to all,
I have this full text search query
SELECT name, org_id,
address_id
FROM organization
WHERE org_ac
Hi to all,
I have this full text search query
SELECT name, org_id,
address_id
FROM organization
WHERE org_active='Y' AND MATCH(name) AGAINST('AB&C*' IN BOOLEAN
MODE)
and I'm not getting any results. And there IS a org AB&C,
Inc.
My assumption i
>-Original Message-
>From: mos [mailto:mo...@fastmail.fm]
>Sent: Wednesday, March 03, 2010 5:14 PM
>To: mysql@lists.mysql.com
>Subject: Tip: Full Text Searches
>
>Something I didn't realize about full text searches, but they can be used
>with multi-table view
Something I didn't realize about full text searches, but they can be used
with multi-table views!
Maybe I'm the last one on the planet to discover this, but I think this is
really neat.
For example, I can create a view with all the fulltext index column of the
customer table (nam
Practical Full-Text Search in MySQL
http://forge.mysql.com/wiki/Practical_Full-Text_Search_in_MySQL
This Thursday (December 3rd, 16:00 UTC – note the different time), Bill
Karwin will talk about Practical Full-Text Search in MySQL. He'll
introduce and compare five different approaches of
Sorry, I don't understand your answer. Could you kindly explain in more details?
Thanks,
Jack
--- On Fri, 4/24/09, zhu dingze wrote:
From: zhu dingze
Subject: Re: Full Text Search Problem
To: mysupp...@asuma.com
Cc: mysql@lists.mysql.com
Date: Friday, April 24, 20
'Words' shows in more than 50% rows will be regards as a stop words.
2009/4/24
> Hi,
>
> I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
>
> 'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
> ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPA
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM article
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM article
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM article
Hi,
When I use ft_min_word_len=3 under [mysqld] section, mysql fails to start.
ft_min_word_len=3 parameter has been added under [myisamchk] only , which
works.
mysql Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (i686) using readline
5.1
Anyone know about this?
Hi all:
I read in mysql documentation that searches are case-insensitive by
default but this default behaviour can be changed using a latin1_bin
collation. But, is there any way to make searches sensitive or
unsensitive to accents, umlauts, etc.?
I suppose that queries are accent sensitive by def
Hi all:
I have been reading mysql 5.1 documentation and it says that default 50%
threshold for natural language searches can be changed in
storage/myisam/ftdefs.h but, what I have to change to allow indexing of
all words?
This percentage is not explicit in the file, so I don't know what I have
to
> MySQL has no idea how you are presenting the data (html, rtf, etc.),
> so it couldn't hilight the words for you. It should really be that
> tricky using grep and PHP.
>
> Brent
I have my data as pure text: no html, rtf or something else. That is, one
table with two columns: one for the document
into mail archives but I
didn't find a solution to the following question:
Is there any way to highligh results from a full-text search? I know
some tricky methods using PHP but I want to know if mysql (5.0 or 5.1
versions) offers some methos or function to do this.
I want to write the k
Hi all:
I was reading documentation and searching into mail archives but I
didn't find a solution to the following question:
Is there any way to highligh results from a full-text search? I know
some tricky methods using PHP but I want to know if mysql (5.0 or 5.1
versions) offers some meth
The official table's data.
++---+-+
| id | title | body|
++---+-+
| 1 | MySQL Tutorial| DBMS stands for DataBase ...
Dear Users,
I am facing a problem related to full text search. I am trying to
search non latin characters with no success :(.
I am trying the following queries for searching and only the English one works.
SELECT * FROM bangla_test WHERE MATCH(bn_test) AGAINST('নাম নাই' in
boolean mo
Hi All,
is there a clever way to access the full-text index...
I want to know what the the words that has been indexed...
Many thanks :)
Regards,
HK
50% value or using default 50
%)
thanx and regards
--
View this message in context:
http://www.nabble.com/Full-Text-Search-tp14947073p14947073.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
'%..whatever..&'
UNION
SELECT "I'M A NEWS",ID_NEWS as ID_TO_RETURN
FROM News T1
WHERE TITLE like '%..whatever..&' OR CONTENT like '%..whatever..&'
Aloha!
Claudio Nanni
-Messaggio originale-
Da: nikos [mailto:[EMAIL PRO
That is a grate solution.
The problem is that I must have deferent links for each response.
That's the tricky thing!
Thank you
Sebastian Mendel wrote:
nikos schrieb:
Hello list
I have to make a full text search and I want to do it in many tables.
I have deferent tables for books author
On Jan 9, 2008 8:36 AM, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
> nikos schrieb:
> > Hello list
> > I have to make a full text search and I want to do it in many tables.
> > I have deferent tables for books authors and news.
> > Any ideas how to do it?
>
nikos schrieb:
> Hello list
> I have to make a full text search and I want to do it in many tables.
> I have deferent tables for books authors and news.
> Any ideas how to do it?
three separate queries or an UNION
--
Sebastian
--
MySQL General Mailing List
For list ar
Hello list
I have to make a full text search and I want to do it in many tables.
I have deferent tables for books authors and news.
Any ideas how to do it?
Thank you
Nikos
Urms schrieb:
> I'm using pretty standard approach to sorting search results by relevancy:
>
> SELECT DISTINCT product_name,
> MATCH (keywords) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE) AS
> rate
> FROM _TT
> WHERE MATCH ( keywords ) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN
Urms wrote:
I'm using pretty standard approach to sorting search results by relevancy:
SELECT DISTINCT product_name,
MATCH (keywords) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE) AS
rate
FROM _TT
WHERE MATCH ( keywords ) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN
MODE ) >0
OR
n the result but at the
same time it takes only about 0.006 sec without ORDER BY clause.
I understand that ORDER BY is time consuming but maybe someone knows a
different way to have sorting by relevancy.
Thanks in advance!
--
View this message in context:
http://www.nabble.com/Fast-relevance
mos schrieb:
I posted this message twice in the past 3 days, and it never gets on
the mailing list. Why?
Here it is again:
I have a Text field that contains paragraph text and for security
reasons I need to have it encrypted. If I do this, how can I still
implement full text search on it
From: Baron Schwartz <[EMAIL PROTECTED]>
To: mos <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, October 26, 2007 3:54:11 PM
Subject: Re: How to encrypt Text and still be able to use full text search?
3rd Attempt ++
> I also need to protect a couple dozen Float fields
I also need to protect a couple dozen Float fields and thought I could
obscure them a bit by adding an offset to them based on an encrypted id
stored with each row. It is not going to be as good as encryption but
will help to obfuscate the data.
How much will obfuscation save you? Are you sav
ty, so you can't do what you're trying to do (secure data in an
> insecure environment). Rent a T1 line for $500/mo and charge customers
> what the data is worth.
>
> Baron
I also agree, however for the sake of argument could we assume that the
order of the wording in the ent
At 12:31 PM 10/26/2007, you wrote:
[EMAIL PROTECTED] wrote:
mos wrote:
The data is quite valuable because there is a lot of competition in this
particular marketplace and my competitors would like to get their hands
on it. I've spent 5 years writing the software and generating the data.
Le
rying to do (secure data in an
> insecure environment). Rent a T1 line for $500/mo and charge customers
> what the data is worth.
>
> Baron
I also agree, however for the sake of argument could we assume that the
order of the wording in the entry probably imparts a significant amount
[EMAIL PROTECTED] wrote:
mos wrote:
The data is quite valuable because there is a lot of competition in
this particular marketplace and my competitors would like to get their
hands on it. I've spent 5 years writing the software and generating
the data. Let's say for the sake of argument the
mos wrote:
The data is quite valuable because there is a lot of competition in this
particular marketplace and my competitors would like to get their hands
on it. I've spent 5 years writing the software and generating the data.
Let's say for the sake of argument the data is worth $1 million.
t; need to have it encrypted. If I do this, how can I still implement full
> text search on it?
> Also, I have a lot of Float columns that need to be protected but the user
> has to use comparison operators like ">" and "<" on them. Any
recommendations?
Hi,
This i
s, how can I still implement full
> text search on it?
> Also, I have a lot of Float columns that need to be protected but the user
> has to use comparison operators like ">" and "<" on them. Any recommendations?
Hi,
This is quite a difficult one, and as usual i
I posted this message twice in the past 3 days, and it never gets on the
mailing list. Why?
Here it is again:
I have a Text field that contains paragraph text and for security reasons I
need to have it encrypted. If I do this, how can I still implement full
text search on it?
Also, I have a
a) You setup a special index (full text).
b) Full text indexes can only be created on MyISAM table types.
c) MyISAM does support transactions, it works by table locking. If
you are not specifically using transactions, you don't need to worry
about it. "not transaction safe"
David T. Ashley wrote:
I'm sending this again, because the server seems to have been down for
several hours, and I'm not sure if it went out.
Yes, I've been getting messages from yesterday, too. But I did get both
of your messages. I don't know what's up.
I'
in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.
- Original Message -
From: "David T. Ashley" <[EMAIL PROTECTED]>
To:
Sent: Friday, July 06, 2007 9:19 PM
Subject: Full Text Search,
I'm sending this again, because the server seems to have been down for
several hours, and I'm not sure if it went out.
-
I'd like to do full text search on some fields of some tables, but I'm a bit
confused by the documentation. Questions:
a)How do I set that up (i
I'd like to do full text search on some fields of some tables, but I'm a bit
confused by the documentation. Questions:
a)How do I set that up?
b)What storage engines are required?
c)Are there any restrictions on "mixing and matching" tables?
d)Do table locking and transa
ssage -
From: "William Langshaw" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, November 29, 2006 12:54 AM
Subject: Full-text searching with quoted bind variables
I am using Full-Text searching with In Boolean Mode. I am generating
my query by using binding parameters. If a user typ
I am using Full-Text searching with In Boolean Mode. I am generating
my query by using binding parameters. If a user types in a quoted
string on the search form (in order to match that string as-is), the
binding mechanism escape it with a backslash. The query runs fine and
it appears to return
Leandro Guimarães Faria Corcete DUTRA wrote:
On Wed, 08 Nov 2006 18:51:20 -0800, Rares Vernica wrote:
Is it possible to access the Full-Text Index structures from SQL?
What do you mean exactly? SQL is not intended for physical structures.
I started writing a little
sql.com
Sent: Tuesday, November 14, 2006 1:09:31 AM GMT-0500 US/Eastern
Subject: Re: access full-text index
I think the full-text index is an inverted index structure. So, it has
all the words from the fields it indexes. For each word it has a list of
record ID which have that word.
What I am inte
I think the full-text index is an inverted index structure. So, it has
all the words from the fields it indexes. For each word it has a list of
record ID which have that word.
What I am interested to get is this inverted index structure. I imagine
it can be represented as 1-2 table(s). Can I
ject: Re: access full-text index
On Wed, 08 Nov 2006 18:51:20 -0800, Rares Vernica wrote:
> Is it possible to access the Full-Text Index structures from SQL?
What do you mean exactly? SQL is not intended for physical structures.
--
Leandro Guimarães Faria Corcete DUTRA+55
On Wed, 08 Nov 2006 18:51:20 -0800, Rares Vernica wrote:
> Is it possible to access the Full-Text Index structures from SQL?
What do you mean exactly? SQL is not intended for physical structures.
--
Leandro Guimarães Faria Corcete DUTRA+55 (11) 5685 2219
h
Hi,
Is it possible to access the Full-Text Index structures from SQL?
Thanks a lot,
Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mmand will help a lot, and is an alternate method of
achieving backups.
Dan
On 8/18/06, AmirBehzad Eslami <[EMAIL PROTECTED]> wrote:
Dear list,
I'm programming a PHP-driven Search Engine for a newspaper.
Full-text Search with MyISAM Tables, MySQL 4.1.11, PHP 4.3.0
1GB of Text encode
Dear list,
I'm programming a PHP-driven Search Engine for a newspaper.
Full-text Search with MyISAM Tables, MySQL 4.1.11, PHP 4.3.0
1GB of Text encoded by UTF-8
An average of 1Mbyte Data is inserted to database every day
A common SQL-Query:
SELECT COUNT(*) FROM news_archive
WHERE
At 05:27 PM 8/2/2006, you wrote:
Hi!
I'm getting a lot of pushback on using mysql for full-text searching on
over 30,000,000 documents. It's starting to slow down when using more than
10-15 keywords. Is there an alternative anyone is using?
I don't want to replace the dat
using mysql for full-text searching on over 30,000,000 documents. It's starting to slow down when using more than 10-15 keywords. Is there an alternative anyone is using?
I don't want to replace the database, but I do need to speed up the keyword
search.
Any ideas? Thanks in advance!
--
Hi!
I'm getting a lot of pushback on using mysql for full-text searching on over
30,000,000 documents. It's starting to slow down when using more than 10-15
keywords. Is there an alternative anyone is using?
I don't want to replace the database, but I do need to speed up the
Peter Lauri schrieb:
Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client. It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English
Hi Peter,
Definitely using OR will slow up the performance of FULL TEXT searching.
Instead of using OR, you can try using UNION statement.
Hope this will be a fix for your issue.
Thanks,
ViSolve MySQL Support Team.
- Original Message -
From: "Peter Lauri" <[EMAIL PR
Why can the Thai and Chinese not use regular sentences and word delimiter :)
So I have to stick to my LIKE thing, just to erase the FULL TEXT index I
assume.
-Original Message-
From: Neculai Macarie [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 20, 2006 10:50 PM
To: mysql
E '%$value%'"
}
If there are many search words, the OR will grow a bit, and OR are not that
fast as I read somewhere.
/Peter
-Original Message-
From: JC [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 20, 2006 10:46 PM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: F
Peter Lauri wrote:
> Best group member,
>
> I have a problem. I was going to use FULL TEXT search for my Thai
> client. It is working smooth with English text and wordings, the
> indexing and search works fine.
"The FULLTEXT parser determines where words start and end by
don't know about indexing, but try to search: LIKE '%sentences%'
JC
On Thu, 20 Jul 2006, Peter Lauri wrote:
> Best group member,
>
> I have a problem. I was going to use FULL TEXT search for my Thai client. It
> is working smooth with English text and wordings, the
Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client. It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English and other languages. I
Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client. It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English and other
, etc. None of which mysql would index.
What I did was created a word conversion list and added a search words field to the database. The search words field would contain
the problematic search words into strings that MySQL would index (CPlusPlus, CSharp, dotNET, etc). The full text index would then
Hi All,
I am using the MySQL full text search capability in the search workflow
in my appplication. I found that MySQL treats special character like
*./,* etc. as tokenizers if they are not specified within a
phrase(inside double quotes). For ex. If the search string entered is
M.B.A or 24/7
have full text index on each of their columns.
Table 1 - forums_topics field - topic
Table 2 - forums_messages field - message
Is it possible to search them both in one query and determine which table
the result is being returned from in the search results?
Thanks
St
I have 2 tables which have full text index on each of their columns.
Table 1 - forums_topics field - topic
Table 2 - forums_messages field - message
Is it possible to search them both in one query and determine which table
the result is being returned from in the search results?
Thanks
* Domain Registration, .COM for as low as fifteen dollars a year,
.COM.AU for fifty dollars two years!
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 June 2006 2:07 AM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Full-Text problems
ot;%dealer%" or field like "%contact%"
Remember, by default full text will find records that contain any of the words you are searching on. If you want to find only
records that contain all the words, you need to do full text boolean search.
- Original Message -
From:
!
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 21 June 2006 10:24 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Full-Text problems
Perhaps the searches that return "nothing" are actually matching more than
50% of the record in
"Taco Fleur" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, June 21, 2006 12:21 AM
Subject: Full-Text problems
Hi all,
I am experiencing some issues with Full-Text and was hoping someone could
shed some light on the following.
I have some content which I know contains for example the w
Hi all,
I am experiencing some issues with Full-Text and was hoping someone could
shed some light on the following.
I have some content which I know contains for example the word "news", the
table is MyISAM, the column type is LONGTEXT, there is an index on the
column of FULLTEXT
Is there a way to escape the parenthesis?
-Original Message-
From: Gerald L. Clark [mailto:[EMAIL PROTECTED]
Sent: Friday, June 09, 2006 6:18 AM
To: Mark Steudel
Cc: mysql@lists.mysql.com
Subject: Re: Question on full text search scores, different content same
score
Mark Steudel wrote
Apologize if this is a dup message:
I was doing a full text search and had a question on why two different
entries got the same score:
Here is my select statement
SELECT
id,
pubyear,
MATCH ( title ) AGAINST ( 'Nursing home federal requirements, guidelines to
surveyors, and survey protocols
Mark Steudel wrote:
I was doing a full text search and had a question on why two different
entries got the same score:
Here is my select statement
SELECT
id,
pubyear,
MATCH ( title ) AGAINST ( 'Nursing home federal requirements, guidelines to
surveyors, and survey protocols (MLM)&
I was doing a full text search and had a question on why two different
entries got the same score:
Here is my select statement
SELECT
id,
pubyear,
MATCH ( title ) AGAINST ( 'Nursing home federal requirements, guidelines to
surveyors, and survey protocols (MLM)' ) AS score,
title
FR
MySQL 5.0.19 running in Apache 2 on Mac OS X 10.4.6
I've been dipping my newbie toe into the murky waters of full text
searching, but not with a great deal of success. I have a complex
search set up which searches nine tables (potentially a whole bunch
more, but for the present pu
IIRC, I think what you need may be in here somewhere:
12.7. Full-Text Search Functions
12.7.1. Boolean Full-Text Searches
12.7.2. Full-Text Searches with Query Expansion
12.7.3. Full-Text Stopwords
12.7.4. Full-Text Restrictions
12.7.5. Fine-Tuning MySQL Full-Text Search
http://dev.mysql.com
low as fifteen dollars a year,
.COM.AU for fifty dollars two years!
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 12 April 2006 3:29 PM
To: Taco Fleur
Cc: mysql@lists.mysql.com
Subject: Re: Full text score
In the last episode (Apr 12), Taco Fleur said:
> is
In the last episode (Apr 12), Taco Fleur said:
> is there such a thing as a score for full-text searches?
Sure. The MATCH function returns one.
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For l
Hi all,
is there such a thing as a score for full-text searches?
thanks in advance.
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an
industry leader with commercial IT experience
/fulltext-fine-tuning.html
(fine tuning full text search)
Sincerely,
Sheeri
On 2/23/06, Anand Sachdev <[EMAIL PROTECTED]> wrote:
> anyone know where i can get these, will highly appreciate, this is a feature
> of mysql 5.0 and my platform is linux.
>
>
--
MySQL General Mailing List
anyone know where i can get these, will highly appreciate, this is a feature
of mysql 5.0 and my platform is linux.
fixes of
the words. The performance of full-text searches some times is low,
however it was improved in 5.1. Pluggable full-text parsers have
appeared in this release as well. For a pity 5.1 is alpha quality now,
and in most cases you shouldn't use it in a production environment.
Hi,
I've always done conventional searches Where ( title like '%$key1%')
or(isynopsis like '%$key2%')
etc etc
But the client has increased the complexity of the search and especially the
size of his database
and the search has really slowed. (particularly now that I have to search a
longtext fi
Hi,
I have a table with consumer products. I have a row "product name"
and "brand".
If I do a full-text search in boolean mode for a term like "apple
ipod" I get results like:
Apple iPod (brand: Apple)
TuneDock for Apple iPod (brand: Belkin)
Hi,
I have a table with consumer products. I have a row "product name" and
"brand".
If I do a full-text search in boolean mode for a term like "apple ipod" I get
results like:
Apple iPod (brand: Apple)
TuneDock for Apple iPod (brand: Belkin)
Mohsen wrote:
> But himself solved his problem.
> with : mysql_query("SET NAMES utf8");
> Even 4.0.x
Wrong.
I decided to prepare two different versions for my software:
- A MySQL 4.0-friendly version using Romanizing method (Hats off to you,
Ehsan)
- A MySQL 4.1-compatible
Hello.
Please could you provide a repeatable test case for this issue? FT
search works fine for me even if one of the columns has empty values.
'Yemi Obembe wrote:
> using the a sql statement like ds:
> select *, match(url, title, comment) against ('movies') as score from dir
> whe
using the a sql statement like ds:
select *, match(url, title, comment) against ('movies') as score from dir
where match(url, title, comment) against ('movies')
where dir is a fulltext table of url, titlke and comment
i however found out that if the comment column is empty it will return an
ny hosting company with PHP 5 and MySQL 4.1
support?
>
> 2) What about if my client only use MySQL 4.0 for his reasons. In
> this case, I really can't use FULL-TEXT search? There is no any
solution?
No. It is inherent in the Fulltext mechanism that the text indexing engine
knows
d you recommand any hosting company with PHP 5 and MySQL 4.1 support?
2) What about if my client only use MySQL 4.0 for his reasons. In this case,
I really can't use FULL-TEXT search? There is no any solution?
Once again, thank you for your reply.
Behzad
of data, encoded with
Unicode(UTF-8).
>
>
> The big deal is to ** reduce the response time ** to end-users.
>
> My first solution is to create an Index and use the "FULL-TEXT
> Searching" method.
>
> Luckily, MySQL's provides FULL-TEXT Indexing sup
1 - 100 of 402 matches
Mail list logo