Making a php query that filters words in a MySQL column -


i'm new both php , mysql, forgive me if simple or common question, looked on , couldn't find answer.

basically, i'm building quick search real estate page can type in address , search results bring (and similar results if type in broad "90th street")

right query looks this. ($quicksearch value typed in.)

$query   =  "select * mlssales (id = '$quicksearch') or (concat_ws(' ',streetnum, streetname) '%$quicksearch%');

now search works me, problem of listings in streetname column contain words "west" or "east" or that. if searches "west 90th street", "300 west 90th street", "300 west 90th", ect. search works. if type "300 90th street" won't results.

how can make search more lenient without making lenient bring in bad results.

what you'd need fulltext search, or manipulate search text make more wildcarded.

your query boils down to

... '%300 90th street'

which works if 3 words next each other 1 space between them.

a full text search treat more as

... '%300%' or '%90th%' or '%street%'

(as hacky example). if can't use fulltext index on table, can try of pre-processing turn each word in search phrase own little 'like' clause. performance suck, because `%...%' clauses can't use indexes, allow arbitrary matches.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more