How to search singular/plurals in php mysql -


when enter word (ex: freshers) want fresher , freshers records both getting freshers records. code this:

$search='freshers'; $qry=mysql_query("select count(*) jobs job_title '%$search%' or match(job_title) against('$search' in boolean mode)");

when search word freshers m getting count 1200. when search word fresher again getting count 2000.

how same count when enter either freshers or fresher.

you cannot precisely same matching-record count mysql technology search term that's either singular or plural.

mysql doesn't have smarts know freshers plural of fresher or children plural of child. if want mysql you'll have start search singular form of word want plural.

neither mysql know mice plural of mouse.

if need automated plural/singular functionality may want investigate lucene or other natural language search tech. name of capability seek "stemming."

but can use fulltext search terms trailing asterisks. example, 'fresher*' matches fresher, freshers, , fresherola. extend search singular plural. not work other way around. it

select count(*)    jobs  match(job_title) against('fresher*' in boolean mode)

there other modifying characters boolean mode search terms. mentioned here:

http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html

pro tip: column '%searchterm%' slowest way mysql offers search column. guaranteed scan whole table.

pro tip: fulltext search inherently bit fuzzy. expecting crisp record counts path confusion.


Comments

Post a Comment

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

request animation frame stops working when exiting fullscreen clicking on original space's safari window. fine if fullscreen mode canceled escape key or calling cancelfullscreen(). steps reproduce: open https://dl.dropboxusercontent.com/u/769042/prezi/safari-fullscreen.html click "draw raf", kittie appears click "fullscreen", go fullscreen click "draw raf", kittie appears go space original safari was, showing "click exit fullscreen mode", click anywhere, out fullscreen click "draw raf", nothing happens what handling click calling: window.requestanimationframe(draw); which draws on canvas context: function draw() { ctx.drawimage(img, math.random()*500|0, math.random()*400|0, 100, 100); } i checked .hidden , .visibilitystate, updated correctly. tested on osx 10.9.3, safari 7.0.4 (9537.76.4). has workaround/solution other switching old settimeout? this sounds webkit bug 88940 : using reque
Read more

Python ctypes access violation with const pointer arguments -

i have api i'm trying wrap in python (2.7.6 on win7) code using ctypes. here's api: client_dllfunc bool clientapi search_exporttoclipcopy(clienthsearch handle, int channel, lpctstr filename, const time_t& from, const time_t& to, const bool* cameras, int length, bool usepassword, lpctstr password, bool includetextin = false, bool excludeplayer = false); the issue i'm having cameras argument; , i've had issue other const pointer arguments well. here's how i'm wrapping api: def search_exporttoclipcopy(self, hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, password, includetextin=true, excludeplayer=false): exporttoclipcopy = self.sdkdll.search_exporttoclipcopy exporttoclipcopy.argtypes = [c_int, c_int, c_wchar_p, c_long, c_long, pointer(c_bool), c_int, c_bool, c_wchar_p, c_bool, c_bool] exporttoclipcopy.restype = c_bool exporttoclipcopy(hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, pass
Read more