ISFDB talk:ISFDB1 Notes

From ISFDB

Jump to: navigation, search

Small project, based on Ahasuerus' desire for "Find all Titles whose Synopsis and/or Note fields contain %%, a remnant of the pre-ISFDB-2 days". BLongley 00:18, 30 April 2011 (UTC)

SQL for generating this page:

select DISTINCT "[http://www.isfdb.org/cgi-bin/title.cgi?" , t.title_id , " " , t.title_title , "] <br>" from titles t, notes n where t.note_id = n.note_id and n.note_note like '%\%\%%'

N.B. SQL to search synopses below, but no results found:

select DISTINCT "[http://www.isfdb.org/cgi-bin/title.cgi?" , t.title_id , " " , t.title_title , "] <br>" from titles t where t.title_synopsis like '%\%\%%'

Retrieved from "http://www.isfdb.org/wiki/index.php/ISFDB_talk:ISFDB1_Notes"