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

Tanjamuse · 10-25-2017, 10:54 AM

I tried to use that column in a SQL query, but didn't get any results:

Code:

SELECT book  FROM books_custom_column_37_link
 WHERE value IN
 ( SELECT value 
 FROM books_custom_column_37_link
 GROUP BY value 
 HAVING COUNT(*) > 1 )

10-25-2017, 10:54 AM	#236
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	I tried to use that column in a SQL query, but didn't get any results: Code: SELECT book FROM books_custom_column_37_link WHERE value IN ( SELECT value FROM books_custom_column_37_link GROUP BY value HAVING COUNT(*) > 1 )