MobileRead Forums - View Single Post - [GUI Plugin] Multi-Column Search

Tanjamuse · 09-29-2017, 12:55 PM

I tried the following but it didn't work. I'm not sure if I added the specific custom column right:

Code:

SELECT book  FROM books_#story_ID_9_link 
 WHERE value IN
 ( SELECT value 
 FROM books_#story_ID_9_link 
 GROUP BY value 
 HAVING COUNT(*) > 1 )

09-29-2017, 12:55 PM	#198
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	I tried the following but it didn't work. I'm not sure if I added the specific custom column right: Code: SELECT book FROM books_#story_ID_9_link WHERE value IN ( SELECT value FROM books_#story_ID_9_link GROUP BY value HAVING COUNT(*) > 1 )