Help with Mysql fulltext search

rekha_shp · March 17, 2010, 6:04am

Hi,

In my site I am using fulltext search to search data from the database using php query.But the search is not working properly and it retrieves irrelevant data.

Can anyone pls guide me how to use mysql fulltext search efficiently.

John_Betong · March 17, 2010, 7:12am

Please supply:

the search script
results expected
irrevelant results received

.

rekha_shp · March 17, 2010, 7:21am

Hi,

The search query is "select title,subject,match(title,subject) against (‘javascript in_array’) from test where match(title,subject) against (‘javascript in_array’)>0 ".

The result I obtain contains all the entry that contains a single word “javascript”.But I want the result to be exact or most relevant.

John_Betong · March 17, 2010, 7:35am

Try this in your PhpMyAdmin:



  SELECT title, subject
  WHERE  (title LIKE '%javascript%'AND title LIKE '%in_array%')	 
  OR
  WHERE  (subject LIKE '%javascript%' AND subject LIKE '%in_array%')
  FROM    test
  ORDER BY title

Hopefully you have the title and subject fields in your table structure set to _ci (case insensitive)

.