At times, we might come across a data that has an empty record or an empty string.
As in the screenshot below, this is inserted by:
insert into artist (artiste, album, price) values ('Bruce Springsteen','',9.60)
If you are new to SQL, you could have wrongly interpreted this as a NULL string.
It is actually an empty string and it can be queried by =” as in:
select * from artist where album=''