mysql - Find entries depending from actual date -


how find specific entries database table. need values of ref when today's date betwenn start , end , state 1. if date not between start , end need values of ref if start , end '0000-00-00' , state 1.

ref start end state 1 0000-00-00 0000-00-00 1 1 2015-07-18 2015-09-05 1 2 0000-00-00 0000-00-00 0 2 2015-05-23 2015-09-04 0 3 0000-00-00 0000-00-00 1 4 2015-07-18 2015-09-05 0 5 0000-00-00 0000-00-00 1 5 2015-07-18 2015-09-05 0 6 0000-00-00 0000-00-00 1 6 2015-07-18 2015-09-05 1 7 0000-00-00 0000-00-00 1 7 2015-06-27 2015-09-04 0 8 0000-00-00 0000-00-00 1 8 2015-06-27 2015-09-04 0 9 0000-00-00 0000-00-00 1 9 2015-06-27 2015-09-04 0 10 0000-00-00 0000-00-00 0 10 2015-06-27 2015-09-04 1 11 0000-00-00 0000-00-00 1 11 2015-06-27 2015-09-04 0 12 0000-00-00 0000-00-00 1 12 2015-06-27 2015-09-04 0 13 0000-00-00 0000-00-00 1 13 2015-05-23 2015-09-04 0 14 0000-00-00 0000-00-00 0 14 2015-05-23 2015-09-04 1 15 0000-00-00 0000-00-00 1 15 2015-05-23 2015-09-04 0 16 0000-00-00 0000-00-00 1 16 2015-05-23 2015-09-04 0 17 0000-00-00 0000-00-00 1 17 2015-05-23 2015-09-04 0

try this:

select ref table state = 1     , ((mydate between start , end)     or (start = 0000-00-00 , end=0000-00-00 , mydate not between start , end))

Comments

Post a Comment

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more

javascript - Add class to another page attribute using URL id - Jquery -

i have attached id url. ex: when click link 1 , has #tab-2 id , takes me landing page. in landing page have find element has #tab-2 id have add class .active . i tried no luck. please 1 correct code. thanks js fiddle link html <div class="menu"> <ul> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-2">link 1</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-44">link 2</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-74">link 3</a></li> </ul> </div> landing page <div class="tab"> <ul> <li><a id="tab-2" class="active" >link 1 content</a></li> <li><a id="tab-44" >link 2 content</a></li> <li><a id="tab-74" >link 3 content</a></l
Read more

firefox - Where is 'webgl.osmesalib' parameter? -

i'm trying webgl running on firefox (v37.0.2) via software acceleration mesa. tried following steps have been stated in article: http://www.binarytides.com/enable-webgl-firefox-ubuntu/ however, unable find parameter named ' webgl.osmesalib ' in about:config section? has been removed (or renamed)? if yes, how should instruct firefox use mesa's software acceleration webgl? looks support osmesa removed in favour llvmpipe.
Read more