View Single Post
Old 02-16-2016, 06: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,275
Karma: 100614
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