php - Matching multiple similar strings in SQL -

-

so here situation:

i need find way match 2 similar strings, example:

a - samsung galaxy s5 white

b - mobile phone samsung galaxy s5 white

i have string a in database field, have , equivalent string coming outside source. is, same product, if straight search title field, search not yield desired results.

any ideas how make lookup, similar strings? maybe break string tokens? there query write according tokens? ngram lookup feature introduced in mysql 5.7.6 useful in scenario?

any other suggestions?

using like being described in other answers won't work, because text you're searching not substring of what's in database (given example). there couple of ways handle this, depending on situation.

if know in advance different varying strings might supplied with, can create table aliases store strings , link them primary table foreign key.

if don't know them in advance, perhaps because user-supplied search terms, need dynamically build query break terms , search them individually, this:

select ...   table  field '%mobile%'     or field '%phone%'     or field '%samsung%'     or field '%galaxy%'     or field '%s5%'     or field '%white%'

while find correct result, may return false positives (i.e. word "white" or "phone" returned), not way go.

if you're using myisam tables mysql <= 5.5, or myisam or innodb tables mysql >= 5.6, can use full-text searches , match/against, this:

select match( field ) against ( 'mobile', 'phone', 'samsung', 'galaxy', 's5', 'white' ) relevance   table  match( field ) against ( 'mobile', 'phone', 'samsung', 'galaxy', 's5', 'white' in boolean mode)  order relevance desc

this not find rows match, sort them relevance (i.e. how many match). limit 1 row if knew relevant match correct one, or display list of choices beginning relevant.

check out documentation page full-text search functions more info.


Comments

Post a Comment

Popular posts from this blog

qt - Using float or double for own QML classes -

-
i've created components , helper methods using c++ , qt used in qml gui. of methods calculate gui elements (size, transformations, scene graph items creation). target arm 32 bit using opengl / eglfs render output. opengl using float , qml using real (defined double ). what should use in c++ do not lose precision? if use qreal ( double ) shouldn't lose precision. if git grep float in qtbase.git , can find out bit more: dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0-* important behavior changes * dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0- dist/changes-5.2.0- - qt compiled qreal typedef'ed double on dist/changes-5.2.0: platforms. qreal float on arm chipsets before. guarantees more dist/changes-5.2.0- consistent behavior between platforms qt supports, binary dist/chan...
Read more

Create Outlook appointment via C# .Net -

-
i need create outlook appointment using microsoft.office.interop.outlook , while can work locally on own workstation , works if run web application via server's browser, not work when connect server externally. hence, think might permission issue. i changed application pool identity " localsystem " don't access denied error. unfortunately, doesn't work. the app behaves if appointment created, appointment doesn't appear in outlook. here include file on top of aspx.cs page using outlook = microsoft.office.interop.outlook; here code using pop appointment. outlook.application apptapp = new outlook.application(); outlook.appointmentitem appt = apptapp.createitem(outlook.olitemtype.olappointmentitem) outlook.appointmentitem; appt.subject = txtfirstname.text + " " + txtlastname.text; appt.body = txtcomment.text; appt.alldayevent = false; appt.start = datetime.parse(txtreminderdate.text + " 8:00 am"); appt.end = datetime.p...
Read more

ios - Swift Array Resetting Itself -

-
i have 2 arrays: pointhistory , datehistory . have nstimer , , when timer runs out, action called. in action appending int pointhistory , , current date string datehistory . here timer action: func timeraction() { let steppervalue = int(stepper.value) employee.numberofpoints = steppervalue networking.saveemployee(employee, completion: { (error) -> void in if error != nil { let alert = uialertcontroller(title: "error", message: "there error updating \(self.employee.name)'s points", preferredstyle: .alert) let alertaction = uialertaction(title: "ok", style: .cancel, handler: nil) alert.addaction(alertaction) self.presentviewcontroller(alert, animated: true, completion: nil) } }) var dateformatter = nsdateformatter() dateformatter.dateformat = "mm-dd-yyyy" dateformatter.timezone = nstimezone.localtimezone() var date = nsdate() var ...
Read more