[ad_1]
Facebook –
GitHub –
Google+ –
LinkedIn –
reddit –
Support –
thenewboston –
Twitter –
MySQL Database Tutorial – 25 – Full-Text Searching
by
Tags:
Comments
20 responses to “MySQL Database Tutorial – 25 – Full-Text Searching”
-
+THENEWBOSTON THE BEST YOUTUBE CHANNEL
-
You can not search for words like 'gun' or 'bed', as by default, you can only search for minimum 4 letter words.
So for searching 3 letter words or even 2, do the following:Put the following lines in an option file:
[mysqld]
ft_min_word_len=3
Then restart the server and rebuild your FULLTEXT indexes. -
very good. Thanks bro!
-
You saved they day man where were you? Why was your video ranking so low in the search…… but i was sure you must have made this video and here you are……….
-
YOU ARE THE FUCKING MAN I LOVE YOU
-
baby butt lmao
-
perfect works really well.
-
darn it wasted a few days studying how to do this in c++.
-
very nicely done and made me understand. your teaching is fun and relaxing. thank you. and thumbs up
-
Neat 🙂
-
Thanks man, this video set me off in the right direction. I appreciate it
-
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!
-
@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
-
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
-
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
-
what was the purpose of using BOOLEAN MODE? (not explained in the video)
-
BUT the fulltext search cannot identify babyfoot & babyliss….
-
Yeah me too, I think it only supports 4 letter words n above if you try to search for gun,bed or new which really exist from the table, you'll get no results.
-
fuck yeah, thank you, i was looking for something like this. I'm subscribed
-
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.
Leave a Reply