Acessing HTML files in a MySQL database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
wschaepe01
Forum Newbie
Posts: 3
Joined: Tue Aug 26, 2008 8:54 am

Acessing HTML files in a MySQL database

Post 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
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Acessing HTML files in a MySQL database

Post by jaoudestudios »

You can use a LIKE search, however do you want it ordered by relevance?

Are you building the system?
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: Acessing HTML files in a MySQL database

Post by VladSun »

Look for:

MySQL
FULL TEXT SEARCH
There are 10 types of people in this world, those who understand binary and those who don't
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Acessing HTML files in a MySQL database

Post 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?
Post Reply