in reply to DBI match both empty and undef

Hi,

What kind of database you have? For example in Oracle database the empty string becomes null automagically. This is how to select rows where both Tag1 and Tag2 is null. null value in the database is seen as undef in perl. I suppose you use DBI module. 

SELECT * FROM GlossaryMetadata WHERE Tag1 is null AND Tag2 is null;

[download]

Replies are listed 'Best First'.
Re^2: DBI match both empty and undef
by Anonymous Monk on Jan 27, 2019 at 16:05 UTC

    SQLite and MSSQL. Both make a difference between undef and empty, and I would like to match both.

[reply]
      SELECT * FROM GlossaryMetadata WHERE (Tag1 is null or Tag1 = '') AND (
+Tag2 is null or Tag2 = '');

      [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom