for user Lurker17, whole db regardless of subverse
Not the whole DB, only within your posts.
Not the whole DB, only within your posts.
Yeah, that's what I meant; my posts only, title only, any subverse (ie "within the whole db"). My db nomenclature may not be quite up to snuff, it's been years, db's were not my forte ... only worked with them on an infrequent as needed basis ~40 years ago.
(ie "within the whole db")
Not within the whole db, your posts only
SELECT posts FROM "Lurker17" WHERE "terms"
This old dog isn't going to learn the current state of the art relational db nomenclature, methodology and technique overnight ... that's for you younger fellas to master. I left the rat race 20 years ago, so now I can simply sit with other "users" and bitch about everything! Lol! That is particularly funny to me, I was on the other side of that coin all of my career. Feels strange being on the "user" side ... yet I will still try my best to diagnose, debug and propose remedies when I encounter issues/obstacles.
Another issue. The advanced search does not appear to allow me to search comments.
I want to search for a keyword/phrase in a comment I made recently on someone elses post that ties into a new post today. IDK who the OP was.
Screen Shot (pic8.co)
Drop Down Menu: Post Titles, Contents, links
I don't see an option to search comments in the drop down menu?
Did I miss something?
It was essentially the same search criteria I attempted on a whim in my example on POAL (but I was stymied by the > 1 char search criteria rule). I specified only @Lurker17 posts, title only search for single char "Q", any subverse in POAL, at any time. I replicated that same search criteria on Searchvoat.co, also included nsfw posts.
I understand an all user, all subverse, all content search for a single character is nuts, but I had whittled my query down to a title search only, @Lurker17 posts only, any subverse. I have ~17646 posts to date on POAL.
I do understand why you aren't allowing 1 char searches because it would be a waste of cpu - unless the query criteria had reduced the search to a manageable size like one user, titles only. Writing the code to allow this exception cases with reduced search criteria would probably not be worthwhile, 99.99% of all searches will involve > 1 char. I'll get by.