full text search from mysql

[xbl1]

Hello;I am trying to do the full text search from mysql database to slove the following problem.1)for example could be searching for books by Georges Simenon about Maigret, when a user is not sure how to spell “Maigret”.2) another example, a user searching for “database” may really mean that “MySQL”, “Oracle”, “DB2”, and “RDBMS” all are phrases that should match “databases” and should be returned, too. or just solve the first problem.Someone introduce me the "with Query Expansion';but i found this interesting feature could be dangerous. It' s very simple to increase the number of matching rows close to the total number of rows of the table; such a search have no meaningCould anyone help, please.

[aspnetguy]

here is an overview of Full Text Search http://jeremy.zawodny.com/blog/archives/000576.html

[xbl1]

here is an overview of Full Text Search http://jeremy.zawodny.com/blog/archives/000576.html

But this is not what i want.i want the solution of the full text search to deal with the following case.Example. Say I search for 'print', I would get results returned when words such as 'printers, printing, prints etc' are found.Could any one known this solution in here?

[justsomeguy]

If you want to search for a substring, then use LIKE.SELECT * FROM table WHERE field LIKE '%print%'This will find anything containing the string "print".

[xbl1]

If you want to search for a substring, then use LIKE.SELECT * FROM table WHERE field LIKE '%print%'This will find anything containing the string "print".

Can it mixup with "with Query Expansion'"?

[Mr.Jay]

Can it mixup with "with Query Expansion'"?

yes it can