This may work query="regexp_replace(lower(titel), '[ -,.:]', '', 'g') = regexp_replace(lower('SAMj -South african Medical Journal'), '[,.:]', '', 'g')" db(query).select(db.joernaal.titel)
On Nov 4, 5:14 am, Johann Spies <johann.sp...@gmail.com> wrote: > In order to solve inconsistent typing by either people who capture > data or people using search functions I intend to use something like > this in SQL (Postgresql): > > select titel from joernaal > where > regexp_replace(lower(titel), '[ -,.:]', '', 'g') = > regexp_replace(lower('SAMj -South african Medical Journal'), '[ > ,.:]', '', 'g') > > The last line can be handled by python using the input from a form. I > want Postgresql to handle the second last line. > > I suspect this type of query is not possible using DAL (or is it?) and > that I will have to use executesql for that? > > Regards > Johann > -- > May grace and peace be yours in abundance through the full knowledge > of God and of Jesus our Lord! His divine power has given us > everything we need for life and godliness through the full knowledge > of the one who called us by his own glory and excellence. > 2 Pet. 1:2b,3a