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
