query issue in SQL Query for finding empty records

Question

I have a query in SQL where I need to add a condition, to find all the records that have an empty field.

This gave me an error..

SELECT forma.*, SMS_MONTIME.IDTICKET, SMS_MONTIME.MBYLLUR,SMS_MONTIME.time_added
FROM forma 
LEFT JOIN SMS_MONTIME ON forma.ID = SMS_MONTIME.IDTICKET WHERE SMS_MONTIME.IDTICKET ==''

Thanks

Change =='' to ='' just one '=' sign, or use the datalength function as explained here: http://stackoverflow.com/a/33425/752527 — Hanlet Escaño, Dec 18 '12 at 09:30

senK · Accepted Answer · 2012-12-18T09:52:36.677

1

In query use just = for checking not == and for checking null values use is null

SELECT forma.*, SMS_MONTIME.IDTICKET, SMS_MONTIME.MBYLLUR,SMS_MONTIME.time_added
FROM forma 
LEFT JOIN SMS_MONTIME ON forma.ID = SMS_MONTIME.IDTICKET WHERE SMS_MONTIME.IDTICKET ='' or SMS_MONTIME.IDTICKET is null

edited Dec 18 '12 at 09:52

answered Dec 18 '12 at 09:31

senK

2,782
1
27
38

Thank you that worked, how can i find now, values that are not empty? – ossial Dec 18 '12 at 09:34
`is not null` for null values and `!=` for non null values probably – senK Dec 18 '12 at 09:36
1

Thank you for the answer :) I'm accepting it in a few minutes! – ossial Dec 18 '12 at 09:37

score 1 · Answer 2 · answered Dec 18 '12 at 09:37

Try this:

...
WHERE SMS_MONTIME.IDTICKET = '' OR SMS_MONTIME.IDTICKET IS NULL

The issue is, what does "blank" mean: '' or null or more usually both

Also, use = not == (I've never actually tried ==, but I've never seen anyone else either, so it can't be good)

score 0 · Answer 3 · answered Dec 18 '12 at 09:32

try this

"SELECT 
 forma.*, SMS_MONTIME.IDTICKET, SMS_MONTIME.MBYLLUR,SMS_MONTIME.time_added
  FROM forma 
  LEFT JOIN 
   SMS_MONTIME ON forma.ID = SMS_MONTIME.IDTICKET WHERE SMS_MONTIME.IDTICKET =''"

or try this

 WHERE SMS_MONTIME.IDTICKET is null

for not null use

WHERE SMS_MONTIME.IDTICKET is not null

Prahalad Gaggar · Answer 4 · 2012-12-18T10:01:28.337

0

to check an empty field, i.e NULL field one can't use =. U have to use the IS NULL Your query should be like this

SELECT forma.*, SMS_MONTIME.IDTICKET, SMS_MONTIME.MBYLLUR,SMS_MONTIME.time_added
FROM forma 
LEFT JOIN SMS_MONTIME ON forma.ID = SMS_MONTIME.IDTICKET 
WHERE SMS_MONTIME.IDTICKET IS NULL

edited Dec 18 '12 at 10:01

answered Dec 18 '12 at 09:36

Prahalad Gaggar

11,389
16
53
71

query issue in SQL Query for finding empty records

4 Answers4