php - How to prefer prefix over a general "like" result? -

-

so let's have following columns selected when use %un% like search:

fun unlikely mundane

but want prefixed results show first - basically, returned in following order:

unlikely fun mundan

is there simple way in mysql, or have modify array of results after them in php?

i going on php side, although i'm not sure if there's mysql way of doing it.

you add 

order left (column,2) = 'un' desc

that put them @ top


Comments

Post a Comment

Popular posts from this blog

Prolog - Listing -

-
i have problem trying work out code here. let's have these codes: university('university of cambridge', 1, 'united kingdom', 90.3, 92.8, 89.4), university('university of oxford', 2, 'united kingdom', 88.9, 94.8, 88.0). how list out names of universities only? tried doing listing. , listing(university). list out or rules. trying names like: university of cambridge university of oxford this gives 1 name: ?: university(x,_,_,_,_). you can query more ; or space to print of them, use fail driven loop: ?: university(x,_,_,_,_), write(x), nl, fail; true.
Read more

python - can't seem to get an output from my class -

-
i can't seem figure out wrong code , why not getting out. can't seem figure out how expand rectangle. instructions: create method called expand takes offset value , returns copy of rectangle expanded offset in directions. >>> r = rectangle(30, 40, 100, 110) >>> print(r) rectangle(30, 40, 100, 110) >>> r1 = r.expand(offset=3) >>> print(r1) rectangle(27, 37, 106, 116) the original rectangle should not modified. >>> print(r) rectangle(30, 40, 100, 110) negative values should return shrunken rectangle. >>> r2 = r.expand(-5) >>> print(r2) rectangle(35, 45, 90, 100) this have far: class rectangle: def __init__(self, initx, inity, initw, inith): self.x = initx self.y = inity self.w = initw self.h = inith def __str__(self): return('rectangle(' + str(self.x) + ',' + str(self.y) + ',' ...
Read more

orchardcms - change base url in local copy in Orchard CMS -

-
i want copy website (orchard 1.7.2.0) localhost, test things before on live site. ik copied database , de web directory , configured iis. in orchards database changed base url in settings_sitesettings2partrecord table. changed database connection in settings.txt now when enter new base url in browser redirected original url. how can prevent this? can't find other reference original url. thanks in advance answer. i found out went wrong. there rewrite in database originial url (for removing www in url). removed , works.
Read more