Google type searched of a database.

Mailing List

Home

Forum Home

MySQL General - General MySQL discussion

MaxDB - Everything about MaxDB, formerly known as SAP DB

MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP

MySQL++ - Programming with the C++ API to MySQL

ODBC - ODBC with the MySQL Connector/ODBC driver

Java Help - Mostly related to the MySQL Connector/J driver

Perl - Perl support for MySQL with DBI and DBD::mysql

GUI - MySQL GUI Tools

Announcement

Subjects

•	mysql openssl Question
•	mysql:it 's a db not a dbms how it 's possible?!
•	Does the binary log enabling affect the MySQL performances?
•	Strange behavior, Table Level Permission
•	FULLTEXT query format question
•	Preventing Duplicate Entries
•	Comparing and writing out BLOBS
•	Executing MySQL Commands From Within C Program
•	Can 't access mysql after kernel upgrade
•	Mysql 4 0 Oracle Stored Procedure Trigger Conversion
•	Downgrade Mysql from 4 to 3 23
•	MySQL Cluster Software
•	mysql test 4 1 fails with the gis test
•	ERROR 2002: Can 't connect to local MySQL server through socket
•	Getting Identity after INSERT
•	Update one field with more fields from another table
•	ERROR 1045: Access denied for user: 'root@localhost ' (Using password: NO)
•	mysql have same function mthod as Oracle decode()

Google type searched of a database.

Google type searched of a database.

2005-02-07 - By mdangus@(protected)

Back

Reply: 1 2

Does anybody know the best way in MySQL to do an author/title sort of search --
basically like the fast searches performed by google?

What I have is a database with fields for author, title, ISBN and (verbose)
description. I would like to be able to enter a search key comprised of
multiple words or a stock number, and to bring up a list of records which are
sorted by "best match" as to my search string.

If this question goes beyond the basics of MySQL, is there an article or book
on this subject that I might read?

Thanks and have a great day!

Earn $52 per hosting referral at Lunarpages.