MySQL: fetching a null or an empty string -
I know that a NULL value and an empty string ( "" ) value, but if I want to get a value using the keyword or , then I can not find any results for NULL value
is. I want to ask that the table looks like this:
titles_and_tags + ---- + ---------- + ------ + | ID | Title | Tag | + ---- + ---------- + ------ + | 1 | Title 1 Faucet | 2 | Heading 2 | Tag 1 | | 3 | Title 3 Tag 2 | | 4 | Edit | Faucet | 5 | Roudata | Div | + ---- + ---------- + ------ + The use of my query looks like this:
Select <name> * by selecting the name <title> "and" Tag "=" Tag 1 "or" Tag ") * Select * by name </code> </pre> <p> So I get one here Do the rows (id: 1,2), but this result is 0 rows. What have I done? </p> <p> <strong> Edit </strong> </p> <p> Sorry, I Forgotten that my main problem is: </p> <pre> <code> select 'Titles_and_tags` from WHERE' title 'such as "title%" and "tag` =" tag1 " '%' Like 'tag' </code> </pre> <p> then it is more like a closed subject, sorry </p> </div> <p> <div class = "post-text" choose itemprop = "text"> <p> Try </p> <pre> <code> heading * and tags with the title 'WHERE' * </code> </pre> <p> You have a wildcard <code>% < Except "code" and left your <code> "" "heading"% "and (` tag` = "tag1" or "tags" such as </code>, and you enter <code> or </code> should be included in the clause for clarity and clearly to ensure that it is fair with your intention Have been committed, group together logic together. </p> <p> <strong> Edit: </strong> Your edit will match the <code> tag '%' such as </code> all the rows that do not have the tag <code> null </code>. A <code> null </code> value is incorrect with <em> any </em> </code> or <code> is not </code> other than <em> <code> I'm not sure that you What are you trying to do with the last question, but I suspect that the question you asked for was originally what you really want. </P> </div> </html> <br /> <script data-cfasync='false' type='text/javascript' src='//p257699.clksite.com/adServe/banners?tid=257699_495604_10&type=footer&size=37'></script> <script data-cfasync='false' type='text/javascript' src='//p257699.clksite.com/adServe/banners?tid=257699_495604_11&tagid=9'></script> <script type="text/javascript" src="//ylx-1.com/slider.php?section=General&pub=435796&ga=g&side=random"></script> </div> <div class='post-bottom'> <div class='post-footer float-container'> <div class='post-footer-line post-footer-line-1'> </div> <div class='post-footer-line post-footer-line-2'> </div> <div class='post-footer-line post-footer-line-3'> </div> </div> <div class='post-share-buttons post-share-buttons-bottom invisible'> <div class='byline post-share-buttons goog-inline-block'> <div aria-owns='sharing-popup-Blog1-byline-6578558998345785345' class='sharing' data-title='MySQL: fetching a null or an empty string -'> <button aria-controls='sharing-popup-Blog1-byline-6578558998345785345' aria-label='Share' class='sharing-button touch-icon-button' id='sharing-button-Blog1-byline-6578558998345785345' role='button'> <div class='flat-icon-button ripple'> <svg class='svg-icon-24'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_share_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> </div> </button> <div class='share-buttons-container'> <ul aria-hidden='true' aria-label='Share' class='share-buttons hidden' id='sharing-popup-Blog1-byline-6578558998345785345' role='menu'> <li> <span aria-label='Get link' class='sharing-platform-button sharing-element-link' data-href='https://www.blogger.com/share-post.g?blogID=4556346130584769873&postID=6578558998345785345&target=' data-url='https://comtrycde11.blogspot.com/2013/03/mysql-fetching-null-or-empty-string.html' role='menuitem' tabindex='-1' title='Get link'> <svg class='svg-icon-24 touch-icon sharing-link'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_24_link_dark' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> <span class='platform-sharing-text'>Get link</span> </span> </li> <li> <span aria-label='Share to Facebook' class='sharing-platform-button sharing-element-facebook' data-href='https://www.blogger.com/share-post.g?blogID=4556346130584769873&postID=6578558998345785345&target=facebook' data-url='https://comtrycde11.blogspot.com/2013/03/mysql-fetching-null-or-empty-string.html' role='menuitem' tabindex='-1' title='Share to Facebook'> <svg class='svg-icon-24 touch-icon sharing-facebook'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_24_facebook_dark' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> <span class='platform-sharing-text'>Facebook</span> </span> </li> <li> <span aria-label='Share to X' class='sharing-platform-button sharing-element-twitter' data-href='https://www.blogger.com/share-post.g?blogID=4556346130584769873&postID=6578558998345785345&target=twitter' data-url='https://comtrycde11.blogspot.com/2013/03/mysql-fetching-null-or-empty-string.html' role='menuitem' tabindex='-1' title='Share to X'> <svg class='svg-icon-24 touch-icon sharing-twitter'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_24_twitter_dark' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> <span class='platform-sharing-text'>X</span> </span> </li> <li> <span aria-label='Share to Pinterest' class='sharing-platform-button sharing-element-pinterest' data-href='https://www.blogger.com/share-post.g?blogID=4556346130584769873&postID=6578558998345785345&target=pinterest' data-url='https://comtrycde11.blogspot.com/2013/03/mysql-fetching-null-or-empty-string.html' role='menuitem' tabindex='-1' title='Share to Pinterest'> <svg class='svg-icon-24 touch-icon sharing-pinterest'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_24_pinterest_dark' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> <span class='platform-sharing-text'>Pinterest</span> </span> </li> <li> <span aria-label='Email' class='sharing-platform-button sharing-element-email' data-href='https://www.blogger.com/share-post.g?blogID=4556346130584769873&postID=6578558998345785345&target=email' data-url='https://comtrycde11.blogspot.com/2013/03/mysql-fetching-null-or-empty-string.html' role='menuitem' tabindex='-1' title='Email'> <svg class='svg-icon-24 touch-icon sharing-email'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_24_email_dark' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> <span class='platform-sharing-text'>Email</span> </span> </li> <li aria-hidden='true' class='hidden'> <span aria-label='Share to other apps' class='sharing-platform-button sharing-element-other' data-url='https://comtrycde11.blogspot.com/2013/03/mysql-fetching-null-or-empty-string.html' role='menuitem' tabindex='-1' title='Share to other apps'> <svg class='svg-icon-24 touch-icon sharing-sharingOther'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_more_horiz_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> <span class='platform-sharing-text'>Other Apps</span> </span> </li> </ul> </div> </div> </div> </div> </div> </div> </div> <section class='comments embed' data-num-comments='0' id='comments'> <a name='comments'></a> <h3 class='title'>Comments</h3> <div id='Blog1_comments-block-wrapper'> </div> <div class='footer'> <div class='comment-form'> <a name='comment-form'></a> <h4 id='comment-post-message'>Post a Comment</h4> <a href='https://www.blogger.com/comment/frame/4556346130584769873?po=6578558998345785345&hl=en-GB&saa=85391&origin=https://comtrycde11.blogspot.com&skin=contempo' id='comment-editor-src'></a> <iframe allowtransparency='allowtransparency' class='blogger-iframe-colorize blogger-comment-from-post' frameborder='0' height='410px' id='comment-editor' name='comment-editor' src='' width='100%'></iframe> <script src='https://www.blogger.com/static/v1/jsbin/1345082660-comment_from_post_iframe.js' type='text/javascript'></script> <script type='text/javascript'> BLOG_CMT_createIframe('https://www.blogger.com/rpc_relay.html'); </script> </div> </div> </section> </article> </div> <style> .post-body a.b-tooltip-container { position: relative; display: inline-block; } .post-body a.b-tooltip-container .b-tooltip { display: block !important; position: absolute; top: 100%; left: 50%; transform: translate(-20%, 1px); visibility: hidden; opacity: 0; z-index: 1; transition: opacity 0.2s ease-in-out; } .post-body a.b-tooltip-container .b-tooltip iframe { width: 200px; height: 198px; max-width: none; border: none; border-radius: 20px; box-shadow: 1px 1px 3px 1px rgba(0, 0, 0, 0.2); } @media (hover: hover) { .post-body a.b-tooltip-container:hover .b-tooltip { visibility: visible; opacity: 1; } } </style> </div><div class='widget PopularPosts' data-version='2' id='PopularPosts1'> <h3 class='title'> Popular posts from this blog </h3> <div class='widget-content'> <div role='feed'> <article class='post' role='article'> <h3 class='post-title'><a href='https://comtrycde11.blogspot.com/2015/02/python-rename-keys-in-dictionary.html'>python - rename keys in a dictionary -</a></h3> <div class='post-header'> <div class='post-header-line-1'> <span class='byline post-timestamp'> - <meta content='http://comtrycde11.blogspot.com/2015/02/python-rename-keys-in-dictionary.html'/> <a class='timestamp-link' href='https://comtrycde11.blogspot.com/2015/02/python-rename-keys-in-dictionary.html' rel='bookmark' title='permanent link'> <time class='published' datetime='2015-02-15T02:22:00-08:00' title='2015-02-15T02:22:00-08:00'> February 15, 2015 </time> </a> </span> </div> </div> <div class='item-content float-container'> <div class='popular-posts-snippet snippet-container r-snippet-container'> <div class='snippet-item r-snippetized'> I want to change the names of keys in a dictionary which are ints, and I need them so that the inputs with key zero They can sort correctly. For example, my keys are like this: '1', '101', '11' and I may need them: '001', '101', '011' What is doing, but I know that there is a better way tmpDict = {} in the ADC for the old: t MpDict ['% 04d'% int (olden)] = addict [oldkey] New controlled = tmpDict You are going wrong about this if you want to draw entries on a line in a specific way, then you have to sort on the extraction. for sorted (D, key = int): print '% s:% R'% (k, d [k]) </div> <a class='snippet-fade r-snippet-fade hidden' href='https://comtrycde11.blogspot.com/2015/02/python-rename-keys-in-dictionary.html'></a> </div> <div class='jump-link flat-button ripple'> <a href='https://comtrycde11.blogspot.com/2015/02/python-rename-keys-in-dictionary.html' title='python - rename keys in a dictionary -'> Read more </a> </div> </div> </article> <article class='post' role='article'> <h3 class='post-title'><a href='https://comtrycde11.blogspot.com/2015/09/windows-heroku-throws-sqlite3-read-only.html'>windows - Heroku throws SQLITE3 Read only exception -</a></h3> <div class='post-header'> <div class='post-header-line-1'> <span class='byline post-timestamp'> - <meta content='http://comtrycde11.blogspot.com/2015/09/windows-heroku-throws-sqlite3-read-only.html'/> <a class='timestamp-link' href='https://comtrycde11.blogspot.com/2015/09/windows-heroku-throws-sqlite3-read-only.html' rel='bookmark' title='permanent link'> <time class='published' datetime='2015-09-15T03:22:00-07:00' title='2015-09-15T03:22:00-07:00'> September 15, 2015 </time> </a> </span> </div> </div> <div class='item-content float-container'> <div class='popular-posts-snippet snippet-container r-snippet-container'> <div class='snippet-item r-snippetized'> After I deploy the app to Heroku, I have to run migration scripts and get this error message ... ITES \ padrino \ prophetmargin & gt; Heroku Rack AR: Rack mutated! SQLite3 :: ReadOnlyException: only one try to write database to read: CREATE TABLE "schema_migrations" ( "version" varchar (255) NOT NULL) /disk1/home/slugs/215264_925fd2c_65a3/mnt/.bundle/gems/gems/ padrino-core- is 0.9.11 / lib / padrino-core / cli / rake.rb: 9: in `init ' how can this be? I also tried to run Heroku dbpush SQLite: //db/my-db.db and that did not work Horoku sqlite3 but using postgres does not do. I'm not sure why you are receiving this error, however, as I have used sqlite3 in development and when pushing it into its travel, they do some magic which migrates to postgrads. I'm absolutely sure how Heroku does 'backwash' this database but it seems that this is happening to you because it's the SQLite db file which is obviously due to Heroku's... </div> <a class='snippet-fade r-snippet-fade hidden' href='https://comtrycde11.blogspot.com/2015/09/windows-heroku-throws-sqlite3-read-only.html'></a> </div> <div class='jump-link flat-button ripple'> <a href='https://comtrycde11.blogspot.com/2015/09/windows-heroku-throws-sqlite3-read-only.html' title='windows - Heroku throws SQLITE3 Read only exception -'> Read more </a> </div> </div> </article> <article class='post' role='article'> <h3 class='post-title'><a href='https://comtrycde11.blogspot.com/2015/09/lex-building-lexical-analyzer-in-java.html'>lex - Building a lexical Analyzer in Java -</a></h3> <div class='post-header'> <div class='post-header-line-1'> <span class='byline post-timestamp'> - <meta content='http://comtrycde11.blogspot.com/2015/09/lex-building-lexical-analyzer-in-java.html'/> <a class='timestamp-link' href='https://comtrycde11.blogspot.com/2015/09/lex-building-lexical-analyzer-in-java.html' rel='bookmark' title='permanent link'> <time class='published' datetime='2015-09-15T03:22:00-07:00' title='2015-09-15T03:22:00-07:00'> September 15, 2015 </time> </a> </span> </div> </div> <div class='item-content float-container'> <div class='popular-posts-snippet snippet-container r-snippet-container'> <div class='snippet-item r-snippetized'> I am currently learning lexical analysis in compiler design. To know how a lexical analyzer actually works, I am trying to build myself. I am planning to make it in Java The input to the lexical analyzer is a .tex file that is of the following format. \ section {script} {intro} \ section {Scope} arbitrary text \ section {relevance} uncontrolled text \ subdivision (profit) arbitrary text \ subsubsection {in real life} \ subdivision {Ingredient} \ end {document} The output of the lecture may be a table of contents with a page number in another file. 1 Introduction 1 1.1 Scope 1 1.2 Relevance 2 1.2.1 Benefits 2 1.2.1.1 Real life 2 1.2.2 loss 3 I hope that This problem is within the scope of Language Analysis Read the .exe file and check '\' and continue to check whether it is actually on search In the sectioning command is set to indicate whether or not a flag variable is the type of sectioning. I hope the above approach will work for the construction of Lexa... </div> <a class='snippet-fade r-snippet-fade hidden' href='https://comtrycde11.blogspot.com/2015/09/lex-building-lexical-analyzer-in-java.html'></a> </div> <div class='jump-link flat-button ripple'> <a href='https://comtrycde11.blogspot.com/2015/09/lex-building-lexical-analyzer-in-java.html' title='lex - Building a lexical Analyzer in Java -'> Read more </a> </div> </div> </article> </div> </div> </div><div class='widget HTML' data-version='2' id='HTML3'> <div class='widget-content'> <!-- PopAds.net Popunder Code for comtrycde11.blogspot.com --> <script type="text/javascript" data-cfasync="false"> /*<![CDATA[/* */ var _pop = _pop || []; _pop.push(['siteId', 2494203]); _pop.push(['minBid', 0]); _pop.push(['popundersPerIP', 0]); _pop.push(['delayBetween', 0]); _pop.push(['default', false]); _pop.push(['defaultPerDay', 0]); _pop.push(['topmostLayer', false]); (function() { var pa = document.createElement('script'); pa.type = 'text/javascript'; pa.async = true; var s = document.getElementsByTagName('script')[0]; pa.src = '//c1.popads.net/pop.js'; pa.onerror = function() { var sa = document.createElement('script'); sa.type = 'text/javascript'; sa.async = true; sa.src = '//c2.popads.net/pop.js'; s.parentNode.insertBefore(sa, s); }; s.parentNode.insertBefore(pa, s); })(); /*]]>/* */ </script> <!-- PopAds.net Popunder Code End --> </div> </div><div class='widget HTML' data-version='2' id='HTML1'> <div class='widget-content'> <script type="text/javascript" src="//ylx-1.com/slider.php?section=General&pub=435796&ga=g&side=random"></script> </div> </div></div> </main> </div> <footer class='footer section' id='footer' name='Footer'><div class='widget Attribution' data-version='2' id='Attribution1'> <div class='widget-content'> <div class='blogger'> <a href='https://www.blogger.com' rel='nofollow'> <svg class='svg-icon-24'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_post_blogger_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> Powered by Blogger </a> </div> <div class='image-attribution'> Theme images by <a href="http://www.offset.com/photos/394244">Michael Elkan</a> </div> </div> </div></footer> </div> </div> </div> <aside class='sidebar-container container sidebar-invisible' role='complementary'> <div class='navigation'> <button class='svg-icon-24-button flat-icon-button ripple sidebar-back'> <svg class='svg-icon-24'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_arrow_back_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> </button> </div> <div class='sidebar_top_wrapper'> <div class='sidebar_top section' id='sidebar_top' name='Sidebar (top)'><div class='widget Profile' data-version='2' id='Profile1'> <div class='wrapper solo'> <div class='widget-content individual'> <a href='https://www.blogger.com/profile/16515500457152977383' rel='nofollow'> <div class='default-avatar-wrapper'> <svg class='svg-icon-24 avatar-icon'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_person_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> </div> </a> <div class='profile-info'> <dl class='profile-datablock'> <dt class='profile-data'> <a class='profile-link g-profile' href='https://www.blogger.com/profile/16515500457152977383' rel='author nofollow'> Unknown </a> </dt> </dl> <a class='profile-link visit-profile pill-button' href='https://www.blogger.com/profile/16515500457152977383' rel='author'> Visit profile </a> </div> </div> </div> </div></div> </div> <div class='sidebar_bottom section' id='sidebar_bottom' name='Sidebar (bottom)'><div class='widget BlogArchive' data-version='2' id='BlogArchive1'> <details class='collapsible extendable'> <summary> <div class='collapsible-title'> <h3 class='title'> Archive </h3> <svg class='svg-icon-24 chevron-down'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_expand_more_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> <svg class='svg-icon-24 chevron-up'> <use xlink:href='/responsive/sprite_v1_6.css.svg#ic_expand_less_black_24dp' xmlns:xlink='http://www.w3.org/1999/xlink'></use> </svg> </div> </summary> <div class='widget-content'> <div id='ArchiveList'> <div id='BlogArchive1_ArchiveList'> <div class='first-items'> <ul class='flat'> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2015/09/'>September 2015<span class='post-count'>418</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2015/08/'>August 2015<span class='post-count'>424</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2015/07/'>July 2015<span class='post-count'>429</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2015/06/'>June 2015<span class='post-count'>388</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2015/05/'>May 2015<span class='post-count'>416</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2015/04/'>April 2015<span class='post-count'>433</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2015/03/'>March 2015<span class='post-count'>439</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2015/02/'>February 2015<span class='post-count'>415</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2015/01/'>January 2015<span class='post-count'>404</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2014/09/'>September 2014<span class='post-count'>405</span></a> </li> </ul> </div> <div class='remaining-items'> <ul class='flat'> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2014/08/'>August 2014<span class='post-count'>457</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2014/07/'>July 2014<span class='post-count'>413</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2014/06/'>June 2014<span class='post-count'>411</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2014/05/'>May 2014<span class='post-count'>408</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2014/04/'>April 2014<span class='post-count'>416</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2014/03/'>March 2014<span class='post-count'>437</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2014/02/'>February 2014<span class='post-count'>408</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2014/01/'>January 2014<span class='post-count'>437</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2013/09/'>September 2013<span class='post-count'>402</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2013/08/'>August 2013<span class='post-count'>403</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2013/07/'>July 2013<span class='post-count'>418</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2013/06/'>June 2013<span class='post-count'>436</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2013/05/'>May 2013<span class='post-count'>392</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2013/04/'>April 2013<span class='post-count'>413</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2013/03/'>March 2013<span class='post-count'>414</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2013/02/'>February 2013<span class='post-count'>402</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2013/01/'>January 2013<span class='post-count'>410</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2012/09/'>September 2012<span class='post-count'>443</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2012/08/'>August 2012<span class='post-count'>412</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2012/07/'>July 2012<span class='post-count'>426</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2012/06/'>June 2012<span class='post-count'>423</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2012/05/'>May 2012<span class='post-count'>425</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2012/04/'>April 2012<span class='post-count'>441</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2012/03/'>March 2012<span class='post-count'>380</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2012/02/'>February 2012<span class='post-count'>410</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2012/01/'>January 2012<span class='post-count'>426</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2011/09/'>September 2011<span class='post-count'>412</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2011/08/'>August 2011<span class='post-count'>427</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2011/07/'>July 2011<span class='post-count'>405</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2011/06/'>June 2011<span class='post-count'>435</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2011/05/'>May 2011<span class='post-count'>439</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2011/04/'>April 2011<span class='post-count'>440</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2011/03/'>March 2011<span class='post-count'>404</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2011/02/'>February 2011<span class='post-count'>429</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2011/01/'>January 2011<span class='post-count'>359</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2010/09/'>September 2010<span class='post-count'>402</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2010/08/'>August 2010<span class='post-count'>420</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2010/07/'>July 2010<span class='post-count'>386</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2010/06/'>June 2010<span class='post-count'>439</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2010/05/'>May 2010<span class='post-count'>391</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2010/04/'>April 2010<span class='post-count'>402</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2010/03/'>March 2010<span class='post-count'>429</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2010/02/'>February 2010<span class='post-count'>408</span></a> </li> <li class='archivedate'> <a href='https://comtrycde11.blogspot.com/2010/01/'>January 2010<span class='post-count'>431</span></a> </li> </ul> </div> <span class='show-more pill-button'>Show more</span> <span class='show-less hidden pill-button'>Show less</span> </div> </div> </div> </details> </div> <div class='widget ReportAbuse' data-version='2' id='ReportAbuse1'> <h3 class='title'> <a class='report_abuse' href='https://www.blogger.com/go/report-abuse' rel='noopener nofollow' target='_blank'> Report Abuse </a> </h3> </div><div class='widget Navbar' data-version='2' id='Navbar1'><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/platform.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar/4556346130584769873?po\x3d6578558998345785345\x26origin\x3dhttps://comtrycde11.blogspot.com', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script><script type="text/javascript"> (function() { var script = document.createElement('script'); script.type = 'text/javascript'; script.src = '//pagead2.googlesyndication.com/pagead/js/google_top_exp.js'; var head = document.getElementsByTagName('head')[0]; if (head) { head.appendChild(script); }})(); </script> </div></div> </aside> <script type="text/javascript" src="https://resources.blogblog.com/blogblog/data/res/4209771381-indie_compiled.js" async="true"></script> <script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/2792570969-widgets.js"></script> <script type='text/javascript'> window['__wavt'] = 'AOuZoY7zXmD2Lo2rXtqFOl4QeZekRplttA:1763969482404';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d4556346130584769873','//comtrycde11.blogspot.com/2013/03/mysql-fetching-null-or-empty-string.html','4556346130584769873'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '4556346130584769873', 'title': 'Com', 'url': 'https://comtrycde11.blogspot.com/2013/03/mysql-fetching-null-or-empty-string.html', 'canonicalUrl': 'http://comtrycde11.blogspot.com/2013/03/mysql-fetching-null-or-empty-string.html', 'homepageUrl': 'https://comtrycde11.blogspot.com/', 'searchUrl': 'https://comtrycde11.blogspot.com/search', 'canonicalHomepageUrl': 'http://comtrycde11.blogspot.com/', 'blogspotFaviconUrl': 'https://comtrycde11.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en-GB', 'localeUnderscoreDelimited': 'en_gb', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Com - Atom\x22 href\x3d\x22https://comtrycde11.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Com - RSS\x22 href\x3d\x22https://comtrycde11.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Com - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/4556346130584769873/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Com - Atom\x22 href\x3d\x22https://comtrycde11.blogspot.com/feeds/6578558998345785345/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'isGoogleEverywhereLinkTooltipEnabled': true, 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/e62bb4d4d9187dd5', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en_GB\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '6578558998345785345', 'pageName': 'MySQL: fetching a null or an empty string -', 'pageTitle': 'Com: MySQL: fetching a null or an empty string -'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard', 'ok': 'Ok', 'postLink': 'Post link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'MySQL: fetching a null or an empty string -', 'description': ' I know that a NULL value and an empty string ( \x22\x22 ) value, but if I want to get a value using the keyword or , then I can not find a...', 'url': 'https://comtrycde11.blogspot.com/2013/03/mysql-fetching-null-or-empty-string.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 6578558998345785345}}, {'name': 'widgets', 'data': [{'title': 'Search This Blog', 'type': 'BlogSearch', 'sectionId': 'search_top', 'id': 'BlogSearch1'}, {'title': 'Com (Header)', 'type': 'Header', 'sectionId': 'header', 'id': 'Header1'}, {'title': 'Featured post', 'type': 'FeaturedPost', 'sectionId': 'page_body', 'id': 'FeaturedPost1', 'postId': '508004463657452899'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'page_body', 'id': 'Blog1', 'posts': [{'id': '6578558998345785345', 'title': 'MySQL: fetching a null or an empty string -', 'showInlineAds': true}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': ''}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}, {'regionName': 'footer3', 'items': [{'name': 'location', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': ''}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': ''}, {'name': 'location', 'label': ''}]}, {'title': '', 'type': 'PopularPosts', 'sectionId': 'page_body', 'id': 'PopularPosts1', 'posts': [{'title': 'python - rename keys in a dictionary -', 'id': 1222649176990616423}, {'title': 'windows - Heroku throws SQLITE3 Read only exception -', 'id': 1058134842119480173}, {'title': 'lex - Building a lexical Analyzer in Java -', 'id': 8596775552059367612}]}, {'title': '', 'type': 'HTML', 'sectionId': 'page_body', 'id': 'HTML3'}, {'title': '', 'type': 'HTML', 'sectionId': 'page_body', 'id': 'HTML1'}, {'type': 'Attribution', 'sectionId': 'footer', 'id': 'Attribution1'}, {'title': 'About Me', 'type': 'Profile', 'sectionId': 'sidebar_top', 'id': 'Profile1'}, {'title': '', 'type': 'BlogArchive', 'sectionId': 'sidebar_bottom', 'id': 'BlogArchive1'}, {'title': '', 'type': 'ReportAbuse', 'sectionId': 'sidebar_bottom', 'id': 'ReportAbuse1'}, {'title': 'Navbar', 'type': 'Navbar', 'sectionId': 'sidebar_bottom', 'id': 'Navbar1'}]}]); _WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch1', 'search_top', document.getElementById('BlogSearch1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'header', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost1', 'page_body', document.getElementById('FeaturedPost1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'page_body', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3049500450-lbx__en_gb.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/828616780-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'page_body', document.getElementById('PopularPosts1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'page_body', document.getElementById('HTML3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'page_body', document.getElementById('HTML1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_AttributionView', new _WidgetInfo('Attribution1', 'footer', document.getElementById('Attribution1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ProfileView', new _WidgetInfo('Profile1', 'sidebar_top', document.getElementById('Profile1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive1', 'sidebar_bottom', document.getElementById('BlogArchive1'), {'languageDirection': 'ltr', 'loadingMessage': 'Loading\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ReportAbuseView', new _WidgetInfo('ReportAbuse1', 'sidebar_bottom', document.getElementById('ReportAbuse1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_NavbarView', new _WidgetInfo('Navbar1', 'sidebar_bottom', document.getElementById('Navbar1'), {}, 'displayModeFull')); </script> </body> </html>