PHP/MySQL Search Engine - Recommendations
Moderator: General Moderators
PHP/MySQL Search Engine - Recommendations
Hi,
I've started to build my own search engine and realized reinventing the wheel wasn't the smartest idea. I want a very good Search Engine, not something basic - I was wondering what ones were out there and what were recommended.
Preferrably something that uses RegExp, as you have much more control than using LIKE in MySQL.
Thanks,
Kerry
I've started to build my own search engine and realized reinventing the wheel wasn't the smartest idea. I want a very good Search Engine, not something basic - I was wondering what ones were out there and what were recommended.
Preferrably something that uses RegExp, as you have much more control than using LIKE in MySQL.
Thanks,
Kerry
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Re: PHP/MySQL Search Engine - Recommendations
AFAIK, google won't read your database no. It will read your web pages though.nyfael wrote:Preferrably something that uses RegExp, as you have much more control than using LIKE in MySQL.
As for using LIKE. That's not a very quick way to search in MySQL. You probably want a FULLTEXT search if your table type allows it. Also, for the record MySQL has REGEXP support
I know, I want a premade search engine that can read my database (MySQL) that uses RegExp, mine uses RegExps right now, but I could seriously contiue improving this for months if not years to get up to some of the best ones today... which is a waste of time and money.
FULLTEXT search - how do I check if I have that functionality?
Thanks,
Kerry
FULLTEXT search - how do I check if I have that functionality?
Thanks,
Kerry
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
I'm not aware of any premade search engines that you can use but I guess there will be some search APIs available.nyfael wrote:I know, I want a premade search engine that can read my database (MySQL) that uses RegExp, mine uses RegExps right now, but I could seriously contiue improving this for months if not years to get up to some of the best ones today... which is a waste of time and money.
FULLTEXT search - how do I check if I have that functionality?
Thanks,
Kerry
As for FULLTEXT, read the manual
http://dev.mysql.com/doc/refman/5.0/en/ ... earch.html
MySQL Manual wrote:Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns.
You don't think there are any out there? There must be, so many sites have them, I'm making an article directory site, and there are many out there that have this functionality, and I highly doubt their programmers each made their own.
Thanks for that! Very useful, I've started reading over it.
-Kerry
Thanks for that! Very useful, I've started reading over it.
-Kerry
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact: