View Single Post
Old 02-16-2016, 05:49 PM   #60
DaltonST
Deviser
DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!DaltonST rocks like Gibraltar!
 
DaltonST's Avatar
 
Posts: 1,103
Karma: 100494
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Version 1.0.44 - Raw SELECT SQL Queries & Keyword REGEXP

Version 1.0.44 - 16 February 2016 New: Raw SELECT SQL Queries can now use the SQLite Regular Expression keyword REGEXP.

Example:

Quote:
SELECT id FROM books WHERE id IN (SELECT book FROM custom_column_8 WHERE value REGEXP '^.+$' )


DaltonST
DaltonST is offline   Reply With Quote