Page 1 of 1

Acessing HTML files in a MySQL database

Posted: Sun Sep 07, 2008 9:33 am
by wschaepe01
I will have about 60,000 HTML files in a MySQL database.The DB will probably have the following fields: ID, Title, content.
In the text of the HTML files will be relative links to the titles of other HTML files in the DB. My client wants to use a search engine to search the DB and display hyperlinks to all files that have say "Abe Lincoln" in the title. Also if there is a link in the text on something, he wants the search engine to be able to scan the database and display that page.

He believes that this can be done with a CMS system.

MY question is this: Do you have any suggestions as to what CMS system or DB search engine might do this?

Regards,
Bill Schaepe

Re: Acessing HTML files in a MySQL database

Posted: Sun Sep 07, 2008 3:56 pm
by jaoudestudios
You can use a LIKE search, however do you want it ordered by relevance?

Are you building the system?

Re: Acessing HTML files in a MySQL database

Posted: Sun Sep 07, 2008 5:12 pm
by VladSun
Look for:

MySQL
FULL TEXT SEARCH

Re: Acessing HTML files in a MySQL database

Posted: Mon Sep 08, 2008 1:54 am
by jaoudestudios
FULL TEXT SEARCH is definitely the way forward, but for a simple list I would use LIKE as it will be much easier for you.

I remember you had trouble getting the html files into the database - I guess that is working now?