Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
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”
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.
I'm not sure what you mean. I don't know what LINQ is and I've never seen those things in C#.
Stored procedure, unique keys, indices are better explained in LINQ. C#. I hope Bucky is working on that too 🙂
Bucky you should really create those stored procedure/function tutorials, and other more advanced sql/database videos. Thanks!
lets run this beast!
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')
u just ALTER the table tae!
thank you …
thank u
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.
they are ranked alphabetically and by length of words. thats what i see.
*cough**cough* … "oh excuse me, I got woopie cough"… haha
whaat is going on guys!
its very useful, thanks bucky !