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
Acessing HTML files in a MySQL database
Moderator: General Moderators
-
wschaepe01
- Forum Newbie
- Posts: 3
- Joined: Tue Aug 26, 2008 8:54 am
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Acessing HTML files in a MySQL database
You can use a LIKE search, however do you want it ordered by relevance?
Are you building the system?
Are you building the system?
Re: Acessing HTML files in a MySQL database
Look for:
MySQL
FULL TEXT SEARCH
MySQL
FULL TEXT SEARCH
There are 10 types of people in this world, those who understand binary and those who don't
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Acessing HTML files in a MySQL database
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?
I remember you had trouble getting the html files into the database - I guess that is working now?