coding search engine

[smartiesz]

Hi there,

I am designing and coding a search engine at the moment. I am using MySQL as a db. I am having some trouble with my design though.

I have done all the html for inserting stuff into the db, and formatting the results. the problem is, I don't know how to store the data in the database so I can search through it, and extract the query easily, and optimally.

I currently have a table with the schema (siteID, URL, keywords) where keywords is a string of comma separated values.

How can I search for a keyword without pulling all the records out of the database and using something like explode() on them?

Anyone got any ideas? I much appreciate any help,

Thank you!

[laserlight]

Perhaps you need to re-design the database structure to avoid using comma separated values.

The relationship between sites and keywords is a many-many relationship, so you probably need an additional table to link them.