mysql - stored with degree symbol, be able to search without, php SQL LIKE statement -

-

i'm haveing abit of trouble search function i've built.

i have column in mysql table called: title (utf8_swedish_ci)

this 2 titles out of around 20.000:

50° riesling réserve trocken   50° parallel riesling trocken

is there somehow can make work user search 50 riesling or 50 parallel, without degree symbol?

my code:

$search = str_replace("\'","’", $_get['searchstring']); $search = htmlentities($search); $search = esc_sql($search); $search = trim($search); if(!empty($_get["searchstring"])){     $str .= "`title` '%".$search."%' , "; }

sql statement (part of it, regarding this):

$res = $wpdb->get_results("select * searchtbl ".$str." order ".$sortby." ".$sort." limit 500");

as question: there "easy" way make user able search 50 riesling , find both items? (its relevant alot of titles not these two)

thanks in advance

you have multiple options, can combine achieve desired output.

  1. create field in table in store titles without specials characters, such ° , run serach on both columns or strip special characters seraches well. if have mysql v5.7.6 or newer, using generated columns ideal solution this.

  2. you can remove these special characters 'on fly', while searching in criteria. again, generated columns faster solution.

  3. use fulltext index , search. however, need reduce default minimum word length 2 , have play around collation file well. this topic contains more information on this.

  4. you can split search string words in php example using explode() , serach words not in single serach criteria, in separate ones.

the advantage of last 2 approaches would find both records if 50 riesling search criteria.


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more