Hi,
can anyone help me if it is possible to make indexing for fulltext from formats in:
1) *.doc
2) *.xls
3) *.html
4) *.pdf
Many thanx for your help 8 4206
"Radim B" wrote: Hi, can anyone help me if it is possible to make indexing for fulltext from formats in:
1) *.doc 2) *.xls 3) *.html 4) *.pdf
Many thanx for your help
Full text indexing works with textual fields in mysql db. So these
format files have to be saved to mysql fields, and in textual format.
E.g. xls can be saved in csv format so it is searchagle. .doc would
have to be saved in .txt format. html would be fine as is.
.pdf would probably require a convertor.
-- http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-fullte...ict130318.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=434942
"steve" wrote: [quote:2a8c8a2c95="Radim B"]Hi, can anyone help me if it is possible to make indexing for fulltext from formats in:
1) *.doc 2) *.xls 3) *.html 4) *.pdf
Many thanx for your help
Full text indexing works with textual fields in mysql db. So these
format files have to be saved to mysql fields, and in textual format.
E.g. xls can be saved in csv format so it is searchagle. .doc would
have to be saved in .txt format. html would be fine as is.
.pdf would probably require a convertor.[/quote:2a8c8a2c95]
Let’s also add that there are a great many tools for free-text
searching of such files, a number of them do understand many different
format files, without any conversion... so I am not sure mysql is the
solution here.
-- http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-fullte...ict130318.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=434943
"Radim B" wrote: Hi, can anyone help me if it is possible to make indexing for fulltext from formats in:
1) *.doc 2) *.xls 3) *.html 4) *.pdf
Many thanx for your help
Full text indexing works with textual fields in mysql db. So these
format files have to be saved to mysql fields, and in textual format.
E.g. xls can be saved in csv format so it is searchagle. .doc would
have to be saved in .txt format. html would be fine as is.
.pdf would probably require a convertor.
-- http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-fullte...ict130318.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=434942
"steve" wrote: [quote:2a8c8a2c95="Radim B"]Hi, can anyone help me if it is possible to make indexing for fulltext from formats in:
1) *.doc 2) *.xls 3) *.html 4) *.pdf
Many thanx for your help
Full text indexing works with textual fields in mysql db. So these
format files have to be saved to mysql fields, and in textual format.
E.g. xls can be saved in csv format so it is searchagle. .doc would
have to be saved in .txt format. html would be fine as is.
.pdf would probably require a convertor.[/quote:2a8c8a2c95]
Let’s also add that there are a great many tools for free-text
searching of such files, a number of them do understand many different
format files, without any conversion... so I am not sure mysql is the
solution here.
-- http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-fullte...ict130318.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=434943
steve <Us************@dbForumz.com> wrote in message news:<zd****************@cyclops.nntpserver.com>.. . "steve" wrote: > [quote:2a8c8a2c95="Radim B"]Hi, > can anyone help me if it is possible to make indexing for fulltext > from formats in: > > 1) *.doc > 2) *.xls > 3) *.html > 4) *.pdf > > Many thanx for your help
Full text indexing works with textual fields in mysql db. So these format files have to be saved to mysql fields, and in textual format. E.g. xls can be saved in csv format so it is searchagle. .doc would have to be saved in .txt format. html would be fine as is.
.pdf would probably require a convertor.[/quote:2a8c8a2c95]
Let?s also add that there are a great many tools for free-text searching of such files, a number of them do understand many different format files, without any conversion... so I am not sure mysql is the solution here.
Can you please tell me which tool? I am trying to find something but
without success.
Thanks.
steve <Us************@dbForumz.com> wrote in message news:<zd****************@cyclops.nntpserver.com>.. . "steve" wrote: > [quote:2a8c8a2c95="Radim B"]Hi, > can anyone help me if it is possible to make indexing for fulltext > from formats in: > > 1) *.doc > 2) *.xls > 3) *.html > 4) *.pdf > > Many thanx for your help
Full text indexing works with textual fields in mysql db. So these format files have to be saved to mysql fields, and in textual format. E.g. xls can be saved in csv format so it is searchagle. .doc would have to be saved in .txt format. html would be fine as is.
.pdf would probably require a convertor.[/quote:2a8c8a2c95]
Let?s also add that there are a great many tools for free-text searching of such files, a number of them do understand many different format files, without any conversion... so I am not sure mysql is the solution here.
Can you please tell me which tool? I am trying to find something but
without success.
Thanks.
"Radim B" wrote: steve <Us************@dbForumz.com> wrote in message news:<zd****************@cyclops.nntpserver.com>.. . "steve" wrote: > [quote:2a8c8a2c95="Radim B"]Hi, > can anyone help me if it is possible to make indexing for fulltext > from formats in: > > 1) *.doc > 2) *.xls > 3) *.html > 4) *.pdf > > Many thanx for your help Full text indexing works with textual fields in mysql db. So these format files have to be saved to mysql fields, and in textual format. E.g. xls can be saved in csv format so it is searchagle. .doc would have to be saved in .txt format. html would be fine as is.
.pdf would probably require a convertor.
Let?s also add that there are a great many tools for free-text searching of such files, a number of them do understand many
different format files, without any conversion... so I am not sure mysql is
the solution here.
Can you please tell me which tool? I am trying to find something but
without success.
Thanks.[/quote:ed65345520]
I don’t have personal experience with any. You may want to start in
google, and search for "text search software" (search both web and
newsgroups).
-- http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-fullte...ict130318.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=435678
"Radim B" wrote: steve <Us************@dbForumz.com> wrote in message news:<zd****************@cyclops.nntpserver.com>.. . "steve" wrote: > [quote:2a8c8a2c95="Radim B"]Hi, > can anyone help me if it is possible to make indexing for fulltext > from formats in: > > 1) *.doc > 2) *.xls > 3) *.html > 4) *.pdf > > Many thanx for your help Full text indexing works with textual fields in mysql db. So these format files have to be saved to mysql fields, and in textual format. E.g. xls can be saved in csv format so it is searchagle. .doc would have to be saved in .txt format. html would be fine as is.
.pdf would probably require a convertor.
Let?s also add that there are a great many tools for free-text searching of such files, a number of them do understand many
different format files, without any conversion... so I am not sure mysql is
the solution here.
Can you please tell me which tool? I am trying to find something but
without success.
Thanks.[/quote:ed65345520]
I don’t have personal experience with any. You may want to start in
google, and search for "text search software" (search both web and
newsgroups).
-- http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-fullte...ict130318.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=435678 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Phil Powell |
last post by:
Relevancy scores are normally defined by a MySQL query on a table that
has a fulltext index. The rules for relevancy scoring will exclude
certain words due to their being too short (minimum...
|
by: Phil Powell |
last post by:
The table already has a fulltext index and from there I can use the
MySQL fulltext search query to get results as well as the relevancy
score.
The problem I have is that MySQL has a default...
|
by: Matt W |
last post by:
Hi all,
I'm planning to use MySQL's full-text search for my forum system
(possibly 5+ million posts). I've been playing with it a lot lately to
see the performance and functionality and have...
|
by: Phil Powell |
last post by:
Retracing my problem leads me to believe I never successfully created
fulltext indexes for MySQL 3.23.58 MyISAM tables. I went to the MySQL
manual and was able - or so I thought - to create them,...
|
by: Robert Oschler |
last post by:
I read a while back that MySQL will only use one index per query. (If this
is not so, please tell me and point me to a doc that gives a good
explanation of MySQL's current index usage policy). ...
|
by: Robert Oschler |
last post by:
I read a while back that MySQL will only use one index per query. (If this
is not so, please tell me and point me to a doc that gives a good
explanation of MySQL's current index usage policy). ...
|
by: pcosway |
last post by:
(originally posted in database.myodbc by mistake)
I'm trying to speed up a fulltext search (MySQL 5.0.21, table has
670,000 records, about 900MBytes, machine has 1GB memory).
Fulltext search...
|
by: saavedrajj |
last post by:
Hi everybody, I need some help. I've started to develop a search for
my PHP site, and I'm using FULLTEXT index
After all, I created the indexs in the required search fields "title"
and "text":...
|
by: John Kotuby |
last post by:
Hi all,
Maybe this belongs in the Full Text group but I am writing an ASP.NET
application with a SQL Server 2005 backend, so I am posing the question
here.
I have been using fulltext search...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| | |