MySQL Database Tutorial – 25 – Full-Text Searching




Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …

Original source


31 responses to “MySQL Database Tutorial – 25 – Full-Text Searching”

  1. hey , i tried to search for items containing 'used' by writing the code –  SELECT name, cost FROM items WHERE MATCH (name) AGAINST ('used') and same for 'of' but both of them are returning empty results , HELP!

  2. @melvin its because google doesnt solely work with mysql it might takes the whatever a person types in that search box n then take that data as a string variable n put that in the clause AGAINST() so the rest of the query could search for that string n match it with the data

  3. In this tutorial u said about using Against() but is Against() compulsory caz I don't find its purpose. Let's say when I use Google to search for the latest movies, how can Google predict earlier what to use inside Against()??? Caz u used a part of the name of the record

  4. Hello. I can't get this working if i try to search multiple colums. With one colum MATCH AGAINST works fine, but if i do example this:
    SELECT * from teachers
    WHERE MATCH (first_name ,last_name)
    AGAINST('John')

    It says #1191 – Can't find FULLTEXT index matching the column list , I can't seem to find the problem

  5. LINQ is one of Csharp features that allow you to pass/return Csharp data structures using SQL queries. Just by using LINQ library in your Csharp class, you can use the methods to set up connection to the SQL data base and run queries. This kind of example is perfect for implementing stored procedures in Csharp.

  6. why when i looking form word 'new' or 'New' – i have no idea does letter matter – i have no result? there is some in table, i run this query
    SELECT name, cst FROM items WHERE Match(name) Against('new')

  7. on my XAMPP 1.7.7 VC9: After

    SELECT name, cost FROM items WHERE MATCH ( name ) AGAINST ( 'baby' )

    I get the message:

    #1191 – Can't find FULLTEXT index matching the column list.

    Pls, what's wrong? What can I do? Thx.

Leave a Reply