tag:blogger.com,1999:blog-18337119.post115498172982378049..comments2024-01-22T07:09:30.574-05:00Comments on MySQL Consulting and NoSQL Consulting: MySQL DBA: Selecting NULLUnknownnoreply@blogger.comBlogger13125tag:blogger.com,1999:blog-18337119.post-12288973602728001162009-11-13T03:56:39.110-05:002009-11-13T03:56:39.110-05:00Enuff with the thanks...Enuff with the thanks...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-48881779005998448262009-07-26T10:24:54.565-04:002009-07-26T10:24:54.565-04:00Another common problem with null values is selecti...Another common problem with null values is selecting fields from the database and expecting null values to be returned with false ones. This blog explains the problem and proper solution:<br /><a href="http://www.tjbourke.com/4" rel="nofollow">http://www.tjbourke.com/4</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-91858488437202608092008-11-20T11:30:00.000-05:002008-11-20T11:30:00.000-05:00thank you.This was a useful postthank you.This was a useful postdeepthihttps://www.blogger.com/profile/13893533811036711316noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-31368727257155691662008-10-23T13:44:00.000-04:002008-10-23T13:44:00.000-04:00I am really curious why the following was never im...I am really curious why the following was never implemented:<BR/><BR/>SELECT * FROM myTable WHERE myColumn = NULL;<BR/><BR/>...just glad that someone posted the function to access null values though - even if it seems like a retarded hack.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-17807420955848400682008-08-13T21:44:00.000-04:002008-08-13T21:44:00.000-04:00Thanks alot for the post. I was freaked out for an...Thanks alot for the post. I was freaked out for an hour before fining you helping post. I tried NULL , null ,'' etc but still wasnt able to get the result. Thank you so muchlonehttps://www.blogger.com/profile/07632071267913045397noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-87456698051099844842008-08-13T21:43:00.000-04:002008-08-13T21:43:00.000-04:00Thanks alot for posting. I was freaked out for an ...Thanks alot for posting. I was freaked out for an hour trying = NULL and = null .. Man i tried every thing in my kitty. Thanks alot you saved you my lifelonehttps://www.blogger.com/profile/07632071267913045397noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-65436819507434733782008-08-04T13:49:00.000-04:002008-08-04T13:49:00.000-04:00Thanks a lot, I was really struggling with this!Thanks a lot, I was really struggling with this!Unknownhttps://www.blogger.com/profile/09753226572772961257noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-64212904387903667072008-06-18T09:27:00.000-04:002008-06-18T09:27:00.000-04:00Thanks for the tip.Thanks for the tip.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-65098386752368522682007-11-20T13:34:00.000-05:002007-11-20T13:34:00.000-05:00What if you had a column of type "text" (and not "...What if you had a column of type "text" (and not "varchar" like in your example)? Then apparently you cannot use IS NULL to test the column for a null value.<BR/>(I get an error message: Error: com.sybase.jdbc3.jdbc.SybSQLException: TEXT and IMAGE datatypes may not be used in a WHERE clause, except with the LIKE expression.<BR/>, SQL State: ZZZZZ, Error Code: 306)<BR/><BR/>Additionally, it seems that depending on the implementation a null value in a text column may be stored by the "null" string, which is evidently not null!<BR/><BR/>From what I gather, Sybase does not support the IS NULL operator for text fields. Using char_lenght() could work for me, as I know that when my field is not null it is a long string, but what if I didn't know this? Is there a way of effectively searching for null values in text fields?<BR/><BR/>Thanks in advance,<BR/><BR/>Javier Masidesjmasideshttps://www.blogger.com/profile/05216656520381186988noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-9943374621712986042007-11-17T11:30:00.000-05:002007-11-17T11:30:00.000-05:00Thank you, this post was very useful.Thank you, this post was very useful.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-90376971174799506842007-09-07T09:24:00.000-04:002007-09-07T09:24:00.000-04:00Good job people<B>Good job people</B>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1168157877021026552007-01-07T03:17:00.000-05:002007-01-07T03:17:00.000-05:00Thanks for the write up, now it is #1 on google. S...Thanks for the write up, now it is #1 on google. Some more crazy ways to find null :<BR/><BR/>select * from table where column < 1Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1155721455337171812006-08-16T05:44:00.000-04:002006-08-16T05:44:00.000-04:00Thank you for this comment. It is really usefull. ...Thank you for this comment. It is really usefull. It was also the second hit by google for 'mysql select null records'.<BR/>:-)Anonymousnoreply@blogger.com