Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    137

    Unanswered: Problem with MySQL Full-Text Search

    I am using the following statement:

    SELECT * FROM patients WHERE MATCH(full_name) AGAINST('jassim ali' WITH QUERY EXPANSION) ORDER BY full_name;

    what I want to display all records contains jassim and should also contains ali but getting totally different result! here are names I am getting in the result:


    Abdul Rahma Salma
    Ali Jassim
    Jassim Rahma
    Jassim Rahma
    Mohd Ali Ahmed
    Mohd Jassim Maki

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    The search is working correctly as you have written it:

    MySQL :: MySQL 5.6 Reference Manual :: 12.9.3 Full-Text Searches with Query Expansion

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •