2015-11-28

strredwolf: (CuteFace)
Every *!)@$*( time I go on DA and search for something, I'm pissed off because its NEVER relevant.

For instance, I know there's three breasted artwork on DA.  There's morphs and drawings.  But searching for it is CRAP.  Instead of "three breast" I get "three AND breast" which matches "three ladies from Bombay clad in wool on top of a Taj Ma Hal replica.  Each one points to various gargoyle creatures objecting to how they have an exposed breast."

In other words, how close the words are together is key, and DA ignores it.  I mean, how simple could it be to add that in?!?

Without any knowledge of DA's setup:

SELECT art_id, INSTR(desc, "three")-INSTR(desc,"breast") AS closeness FROM artwork WHERE desc LIKE "%three%" AND desc LIKE "%breast%" ORDER BY closeness;

...relatively easily, if you build a query on the fly.

Profile

strredwolf: (Default)
STrRedWolf

July 2017

S M T W T F S
      1
23 45678
9101112131415
16171819202122
23242526272829
3031     

Expand Cut Tags

No cut tags