Programming Tools
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingProgramming Tools

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old August 26th, 2002, 03:00 AM
mytch mytch is offline
Dev Articles Novice (500 - 999 posts)
 
Join Date: Apr 2002
Location: Sydney, Australia
Posts: 588 mytch User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 17
Article Discussion: Getting Started With MySQL's Full-Text Search Capabilities

If you have any questions or comments about this article then please post them here.

This forum post relates to this article

Reply With Quote
  #2  
Old August 26th, 2002, 07:52 PM
ckchin ckchin is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2002
Posts: 52 ckchin User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 17
Since Mysql support Full-text Search Full-text Search as of version 3.23.23 and above, is anyone aware of any 'large' serach engine that use mysql as its backends?

Just wondering, what kinds of database used by 'big borther' like Yahoo! Google, Altavista, etc.

Thanks.
__________________
Regrads,

ckchin

Reply With Quote
  #3  
Old August 27th, 2002, 01:34 AM
Lindset Lindset is offline
weirdomoderator
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2002
Location: Alta, Norway
Posts: 370 Lindset User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 17
Send a message via ICQ to Lindset Send a message via AIM to Lindset
I really don't have the slightest idea.. but I'm guessing they've made their own..
__________________
Best Regards,
Håvard Lindset

Reply With Quote
  #4  
Old August 28th, 2002, 12:51 PM
johnn johnn is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2002
Location: Southern California, USA
Posts: 48 johnn User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 17
Is there any problem if I use this feature in a large scale database?

Reply With Quote
  #5  
Old August 28th, 2002, 04:15 PM
Lindset Lindset is offline
weirdomoderator
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2002
Location: Alta, Norway
Posts: 370 Lindset User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 17
Send a message via ICQ to Lindset Send a message via AIM to Lindset
Quote:
Originally posted by johnn
Is there any problem if I use this feature in a large scale database?


I think it's meant for quite large databases. Worth a shot at least

Reply With Quote
  #6  
Old August 30th, 2002, 07:29 PM
jplush76 jplush76 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2002
Posts: 3 jplush76 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I used this tutorial and found it great, except for one question about the "50%" rule....


I have a test database with 24 records/rows

I searched for the word "camera" which is present in 3 rows and it displayed perfectly

I searched for the world "film" which is present in 17 of the 24 rows and it returned 0 results

I imagine this is the 50% rule

how do you get around that? do you send a message back saying be more specific in your search?

do you do an if statement that if mysql_num_rows = 0 do the same search using the LIKE method?

thanks!

Reply With Quote
  #7  
Old August 31st, 2002, 03:44 AM
Lindset Lindset is offline
weirdomoderator
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2002
Location: Alta, Norway
Posts: 370 Lindset User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 17
Send a message via ICQ to Lindset Send a message via AIM to Lindset
Hmm, well.. Since the word film is used so much, there's nothing special about it.. that's my view but yeah, you can do a WHERE columnName LIKE '%searchword%' if you'd like to

Reply With Quote
  #8  
Old August 31st, 2002, 01:00 PM
jplush76 jplush76 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2002
Posts: 3 jplush76 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
well if you're searching an ecommerce site, you have to expect your users to not understand a 50% rule, they want to type something in and get results back, they don't care if its the most common word in the world.

if they are searching for a product they don't know they might not know how to narrow the search.

Reply With Quote
  #9  
Old September 4th, 2002, 10:59 PM
alfatek alfatek is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2002
Posts: 2 alfatek User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
in a query like:
select *, MATCH (title) AGAINST ('hardware guide') as relevance from articles where MATCH (title) AGAINST ('hardware guide') order by relevance DESC

does it retrieves the results that have hardware AND guide or it retrieves hardware OR guide...

i know that the relevance will be diferent but anyway it looks like it uses OR by default...

but i don't understand this full-text searching stuff.... the way relevance is made is not clear, i can't find an explanation of the algorithm they used.

i guess i will just wait for another nice tutorial: how to make a ultra nice search engine for your website

Reply With Quote
  #10  
Old September 16th, 2002, 03:15 AM
Joe4JC Joe4JC is offline
The name's Joe. Yours?
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2002
Location: Lurking in the shadows...
Posts: 147 Joe4JC User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 17
[edit]How do you display the results in PHP? Also,[/edit] how can you display the relevance beside the query? ie.: MyText (100%)

Thanks,
Joe of 4Life
__________________
Check out 4Life today!

Last edited by Joe4JC : September 17th, 2002 at 12:11 AM.

Reply With Quote
  #11  
Old October 23rd, 2002, 09:38 AM
nosta nosta is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2002
Posts: 9 nosta User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Hi everyone !

Quote:
In my next article I will create a full-text search engine using PHP, MySQL and MySQL's full-text Boolean search capabilities.


I was just wondering if this article was coming out soon ... I'm trying to do it myself but well i have to admit it's quite messy and working on my nerves ... .

Anyway thanks for the great articles !

Mike

Reply With Quote
  #12  
Old October 23rd, 2002, 10:46 AM
Lindset Lindset is offline
weirdomoderator
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2002
Location: Alta, Norway
Posts: 370 Lindset User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 17
Send a message via ICQ to Lindset Send a message via AIM to Lindset
Quote:
Originally posted by nosta
Hi everyone !



I was just wondering if this article was coming out soon ... I'm trying to do it myself but well i have to admit it's quite messy and working on my nerves ... .

Anyway thanks for the great articles !

Mike


MySQL 4 (currently in beta) supports boolean search natively

Reply With Quote
  #13  
Old October 23rd, 2002, 12:26 PM
nosta nosta is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2002
Posts: 9 nosta User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
What I mean was that I was trying to make the full-text search engine using PHP .

Reply With Quote
  #14  
Old October 23rd, 2002, 04:02 PM
gcrothers gcrothers is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2002
Posts: 1 gcrothers User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
false !== PROBLEM

I've got the script running o.k
I can see session files being created in a sessions directory that i predefined.
But my count never increases., I had to change false!== coz it would not run with this

I think that the false !== is not supported in my hosted php server
I have tried a loop like this

while ( $file = readdir( $directory_handle ) ) { $count++;......

but still the count does not increase.

can anyone suggest a workaround


garry

Reply With Quote
  #15  
Old November 20th, 2002, 06:41 PM
olivierd olivierd is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Nov 2002
Location: Montréal
Posts: 1 olivierd User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question less than 3 characters

If I understand correctly, searches on words such as 'art', 'ski', 'cat', 'dog', 'car', 'net', 'air', 'old', ..... will never return anything because they are 3 or less characters long and are considered noise words? I need to decide if I should use full-text search for a sport store site search. Most probably, now that winter is here (lots of snow in Quebec), many people will want to search for articles with the word 'ski' in them....

mmmmmm......

thanks
Olivier

Reply With Quote
  #16  
Old November 20th, 2002, 06:44 PM
jplush76 jplush76 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2002
Posts: 3 jplush76 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I suggest against it, I'm using it now and I'm having problems with that 3 word thing as well.

I have to rewrite my search this month

Reply With Quote
  #17  
Old December 12th, 2002, 02:00 AM
aprian aprian is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2002
Location: Indonesia
Posts: 2 aprian User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
i'm a newbie in php+mysql dev. I've already read this article, and it's very helpfull.

I've make a search form, u can see it at :
URL

note : i've not yet input data for Provinsi, Kota and Kecamatan, so it's still empty.


i want to use full text search to find the data from the database. I've alter my table in database :

alter table MyTable add fulltext(field1, field2, field3 ...until... field25)

but mysql report an error that says max field is 16. This is the error :
ERROR 1070: Too many key parts specified. Max 16 parts allowed

How can i doing full text search for that such a lot of query/field ?...give an idea or something to solve this problem

thx for the help.

Reply With Quote
  #18  
Old April 21st, 2003, 03:34 PM
bnow bnow is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Orlando, FL
Posts: 1 bnow User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
You can limit your resultset to show only matching rows where there is relevance grater than zero:

$SqlStr="SELECT ARTICLE, MATCH(ARTICLE) AGAINST('georgia') as new FROM newsletter WHERE
MATCH(ARTICLE) AGAINST ('georgia') > 0 ORDER BY MATCH(ARTICLE) AGAINST('georgia') DESC";

Reply With Quote
  #19  
Old February 8th, 2005, 05:12 AM
purplish_jen purplish_jen is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2005
Posts: 1 purplish_jen User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 8 m 38 sec
Reputation Power: 0
Hi Mitch! Thanks for a great article!

I'd like to ask when will you make your next article - Full-text search engine using PHP, MySQL and MySQL's full-text Boolean search capabilities ?

Reply With Quote
  #20  
Old April 14th, 2005, 02:40 AM
dejaone dejaone is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2005
Posts: 34 dejaone User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 47 m 11 sec
Reputation Power: 14
real search engines won't use any RDBMS for the search.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingProgramming Tools > Article Discussion: Getting Started With MySQL's Full-Text Search Capabilities


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap