On Tuesday, 12. March 2002 06:18, you wrote: > I want to build a MySQL site search. Can anyone help with my 'overview' > > I have written a perl programme to open each html file, cut out all the > tags and create a hash of hashes each word is a key, then the secondary key > is the filename, then the value is the number of occurances in that > document. > > So how should I make my SQL tables? I thought a 2 column > (filename:occurances) table for each word would be the best way, but thats > A LOT of tables. I'd get perl to do all the writing, and I'm sure I could > get it to work this way. > > But is this the best way? I'm fairly new to MySQL so please be explicit! >
Hello. I'm not sure if building a search engine is the right task for a mysql beginner, but maybe this link could be helpful for you: http://www.howstuffworks.com/search-engine.htm Maybe its easier to use an existing engine/code like mnogosearch. Regards Georg (mysql, query) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php