Re: search field into MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Did anyone hear about "match against" construction? I is easy to build
this:

$query = "SELECT *, MATCH field AGAINST ('$searchwords') as relev FROM table
ORDER BY relev DESC"

(you need do "ALTER TABLE table ADD FULLTEXT(field)" before.

This could be usefull:

http://detail.phpclub.net/download/search_with_relevance.txt


Regards, A.K.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux