Re: How do I build a search engine for a MySQL database?
Iman, I read this article yesterday in the morning. :-) The new full text search function of MySQL 4beta is exaclty what I'm looking for. There is only a problem... I don't think my university is going to upgrade to a beta version of MySQL, so I need a perl search algorithm instead. Thanks a lot. - Oriol -
RE: How do I build a search engine for a MySQL database?
Hmm... According to this http://www.mysql.com/doc/en/Fulltext_Search.html it is in 3.2.23. Might want to take a look again. I just have not tried it myself yet. Iman Mayes -Original Message- From: Oriol Portell - UV [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 6:44 AM To: Mayes, Iman; [EMAIL PROTECTED] Subject: Re: How do I build a search engine for a MySQL database? Iman, I read this article yesterday in the morning. :-) The new full text search function of MySQL 4beta is exaclty what I'm looking for. There is only a problem... I don't think my university is going to upgrade to a beta version of MySQL, so I need a perl search algorithm instead. Thanks a lot. - Oriol -
Re: How do I build a search engine for a MySQL database?
Thanks, Kris. I probably expressed myself very bad... Actually I have done almost all the work. That means that I know how to connect to a database and how to manually build SQL statements in order to do a search. But I have a big problem: I don't know how to analize complex text queries and converting them to SQL select statements. For example: entering preposition (place OR time) in a text field and getting the corresponding select statement. I cannot analize myself the text query from an HTML form because I don't know how to do it through regexps. So, the first option is to enter only simple queries and then I add the % wildcard myself to the select statement, but it is not very useful. The perl modules I found in CPAN (Text-Query and Text-Query-SQL) convert complex text queries in Altavista syntax to SQL statements, but they don't put the % wildcard to the query words. These modules allow me to do more or less successful queries, but if I enter the text quoted above -- preposition (place OR time) -- the result does not include all the database entries with prepositions (the plural) and it is a bit annoying... Thanks, - Oriol -
RE: How do I build a search engine for a MySQL database?
Here is a good link to check out: http://www.devarticles.com/art/1/195 Iman Mayes -Original Message- From: Oriol Portell - UV [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 4:30 AM To: [EMAIL PROTECTED] Subject: Re: How do I build a search engine for a MySQL database? Thanks, Kris. I probably expressed myself very bad... Actually I have done almost all the work. That means that I know how to connect to a database and how to manually build SQL statements in order to do a search. But I have a big problem: I don't know how to analize complex text queries and converting them to SQL select statements. For example: entering preposition (place OR time) in a text field and getting the corresponding select statement. I cannot analize myself the text query from an HTML form because I don't know how to do it through regexps. So, the first option is to enter only simple queries and then I add the % wildcard myself to the select statement, but it is not very useful. The perl modules I found in CPAN (Text-Query and Text-Query-SQL) convert complex text queries in Altavista syntax to SQL statements, but they don't put the % wildcard to the query words. These modules allow me to do more or less successful queries, but if I enter the text quoted above -- preposition (place OR time) -- the result does not include all the database entries with prepositions (the plural) and it is a bit annoying... Thanks, - Oriol -