in reply to Recalcitrant placeholders

SELECT idPerson FROM Person WHERE email = 'me@examle.com' OR altEmail = 'me@example.com' ... Hardcoding the email WHERE email = 'me\@example.com' - that works!

Those email addresses are not the same.

🦛

Replies are listed 'Best First'.
Re^2: Recalcitrant placeholders
by Bod (Parson) on Jul 04, 2021 at 22:20 UTC
    WHERE email = 'me@examle.com' OR altEmail = 'me@example.com'

    That fails at compilation time saying that @example is not declared

[reply]
[d/l]
[reply]

      A copy and paste of "examle" is the correct thing to do, but it's not the same as copy and comprehend: "examle" ne "example".

      Update: ENOTENOUGHCOFFEE

      Optimising for fewest key strokes only makes sense transmitting to Pluto or beyond
[reply]
[d/l]

In Section Seekers of Perl Wisdom