Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re: DBI match both empty and undef

by pme (Prior)
on Jan 27, 2019 at 15:21 UTC ( #1229026=note: print w/replies, xml ) Need Help??

in reply to DBI match both empty and undef


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;

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.

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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1229026]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (8)
As of 2020-10-19 16:31 GMT
Find Nodes?
    Voting Booth?
    My favourite web site is:

    Results (205 votes). Check out past polls.