mysql - Counting most common word in SQL table with exclusions -



mysql - Counting most common word in SQL table with exclusions -

i'm trying count mutual words table total of text (strings) in mysql database (using mysql workbench). got code working reading post (written kickstart). code uses separate table called integer 10 columns 0 9 counting.

table schema main table. i'm interested in info "text" column.

'id', 'int(11)', 'no', 'pri', '0', '' 'postid', 'int(11)', 'yes', 'mul', null, '' 'score', 'int(11)', 'yes', 'mul', null, '' 'text', 'varchar(4000)', 'yes', '', null, '' 'creationdate', 'varchar(25)', 'yes', '', null, '' 'userid', 'int(11)', 'yes', 'mul', null, '' 'userdisplayname', 'varchar(255)', 'yes', '', null, ''

sql query:

select aword, count(*) wordoccurancecount (select substring_index(substring_index(concat(text, ' '), ' ', acnt), ' ', -1) aword table cross bring together ( select a.i+b.i*10+c.i*100 + 1 acnt integers a, integers b, integers c) sub1 (length(body) + 1 - length(replace(text, ' ', ''))) >= acnt) sub2 sub2.aword != '' grouping aword order wordoccurancecount desc limit 10

it lists out top 10 words, total of short words a, the, you, me... etc. how can alter skip words those? how can create say, words 5 characters , counted?

schema of integers table 'i', 'int(11)', 'no', 'pri', null, ''

original post , code taken post. new , couldn't post on had inquire here. determining used set of words php mysql

thank much help!

you should able add together status clause:

select aword, count(*) wordoccurancecount (select substring_index(substring_index(concat(text, ' '), ' ', acnt), ' ', -1) aword table cross bring together ( select a.i+b.i*10+c.i*100 + 1 acnt integers a, integers b, integers c) sub1 (length(body) + 1 - length(replace(text, ' ', ''))) >= acnt) sub2 sub2.aword != '' , length(sub2.aword) >= 5 grouping aword order wordoccurancecount desc limit 10

just checking see if length of aword @ to the lowest degree 5 chars, , if so, include in result set. limit applied result set (post-filtering) , should have need.

mysql sql

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more