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.
From:
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
User
Account name:
Password:
If you don't have an account you can create one now.
Subject:
HTML doesn't work in the subject.

Message:

 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

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