Need an algorithm that can scan fulltext from MySQL database.

[dawg00]

Hello,

i am in search of an algorithm that can search for a KEYWORD from fulltext  Mysql table ,

i have used the boolean functions provided in mysql using php, wanted another algorithm that can do searching for keyword..

 

PLZ HELP ME..

[Muddy_Funster]

Can you elaborate on what a "Full Text MySQL Table" is please?

[dawg00]

File name

fulltext

 

its like i want to place contents of  files into columns fulltext.

when i give a keyword as input the rows containing that keyword should be displayed.

[Muddy_Funster]

your question seems to be one of SQL rather than one of php, the SQL you are looking for should be somthing like:

 

$query = "SELECT * from `tablename` MATCH (`columnName1`, `columnName2`, `columnName3`...) AGAINST (`keyword` WITH QUERY EXPANSION)";
$result = mysql_query($query) or die (mysql_error);
while ($row = mysql_fetch_array($result)){
print_r ($row);
}

 

does that help?

[dawg00]

i have used the BOOLEAN SEARCH provided by MYSQL to search fulltext(similar to the query you have showed but uses boolean search expression).

Just wanted to know if there is any other way of doing this fulltext search.

[Muddy_Funster]

That's the only way I know of, but I haven't actualy used fulltext.  Perhaps somone else has a better idea.

[Adam]

You haven't actually said why you don't want to use boolean search. Why do you need another way of doing it when the MySQL manual is clearly stating that's the way to do it?

[dawg00]

I was just curious to know if there is any other way to do the fulltext search.

 

[Mchl]

There is. You can use separate engine like http://www.sphinxsearch.com/