ruby - Does MySQL have a text search that seems to work like Google's? -


i'm making website backend uses mysql , ruby gem sinatra.

my mysql table has longtext column fulltext index.

i've written mysql query that's this:

select plot  mytable match(plot) against('time travel robot')

the first result:

man on moon biographical movie on late comedian andy kaufman. kaufman, along role on taxi (1978), famous being self-declared intergender wrestling champion of world. after beating women time , time again, jerry lawler (who plays himself in movie), professional wrestler, got tired of seeing of , decided challenge kaufman match. in of matches 2 had, lawler prevailed piledriver, move spiking opponent head-first mat. 1 of famous moments in feud in 80s when kaufman threw coffee on lawler on late night david letterman (1982), got fisticuffs lawler, , proceeded sue nbc.

even though movie, has nothing time traveling or robots.

i don't know google's search algorithm, know if mysql has search function ranks results based on how close inputted words are.

in case, i'd relevant results have words "time," "travel" , "robot" close possible.

and nice if dream function variations on words, "travelling" or "robots."

how of possible mysql? or ruby?

or should go different?

google searching performing indexing on large n-gram data using solr(lucene). see

using mysql ruby can surely on large data not fast , effective. small data, happy see result.

a database index data structure improves speed of data retrieval operations on database table @ cost of additional writes , storage space maintain index data structure. see indexing

there various data structure techniques used indexing purpose. can apply on mysql ruby. basic idea check tutorial

so if have large data set, thta performing indexing technique on data, when search on indexed data query time travel robot automatically show related result.


Comments

Post a Comment

Popular posts from this blog

cakephp - simple blog with croogo -

i not problem, made simple blog in croogo, problem is not adding or modifying or delete, because arabic language ?? function add in controller `public function admin_add() { $this->set('title_for_layout', __('add part')); if (!empty($this->request->data)) { $this->part->create(); if ($this->part->save($this->request->data)) { $this->session->setflash(__('the part has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index'));//, $this->part->id)); } else { $this->session->setflash(__('the part not saved. please, try again.'), 'default', array('class' => 'error')); } } }` => model `class part extends appmodel { public $name = 'part'; var $belongst...
Read more

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more

bash - Performing variable substitution in a string -

i have string contains use of variable, , i'd substitute variable's value string. right best have is #!/bin/bash foo='$name; echo bar' name="the name" expanded="$(eval echo "$foo")" echo "$expanded" which has obvious defects: prints the name bar while i'd print the name; echo bar instead of eval can bash's regex matching bash's string replacement: foo='$name; echo bar' name="the name" [[ "$foo" =~ \$([[:alnum:]]+) ]] && s="${!bash_rematch[1]}" && expanded="${foo/\$${bash_rematch[1]}/$s}" echo "$expanded" name; echo bar
Read more