notifications - How can I use MySQL alias in Where condition -

-

i have column date of months in table,
table_date
17
13
12
04
check these date lesser current date
trying, or there other better way.

select concat(date_format(now(),'%y-%m'),'-',table_date) duedate dhr due date < curdate()
have error as
unknown column 'duedate' in 'where clause'

i found concatenating must done in condition

select table_date table_name concat(date_format(now(),'%y-%m'),'-',table_date) < curdate()


Comments

Post a Comment

Popular posts from this blog

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more

c++ - Checking for a nested, templated class -

-
i'm trying build trait checks existence of nested, templated class. take checking whether class o has nested class inner template parameter t : template <typename o, typename t> struct has_inner { static const bool value = std::is_class<typename o::template inner<t> >::value; }; however, not work properly. given 2 example classes dummy , ok struct dummy {}; struct ok { template <typename t> struct inner { }; }; the check on ok std::cout << std::boolalpha << has_inner<ok, float>::value << std::endl; will work, whereas check on dummy std::cout << std::boolalpha << has_inner<dummy, int>::value << std::endl; will fail compile on clang 3.2 error error: 'inner' following 'template' keyword not refer template static const bool value = std::is_class<typename o::template inner<t> >::value; ...
Read more

php - facebook and github login HWIOAuthBundle and FOSUserBundle in Symfony2.1 -

-
i have followed tutotial http://m2mdas.github.io/blog/2013/11/21/integrate-hwioauthbundle-with-fosuserbundle/ make github login work, seems working when clicked login land on github login page, , see 1 user registered on github application in github dashboard. not authencated in symfony. on symfony tool bar on bottom still says anonymous user, plus new row not added table fos_user. for facebook login, when click on generator login link facebook, gives me error "given url not permitted application configuration.: 1 or more of given urls not allowed app's settings. must match website url or canvas url, or domain must subdomain of 1 of app's domains." another doubt had in tutorial, in routing.yml says put, hwi_github_login: pattern: /secure_area/login/check-github as there no controller or resource specified, supposed put here controller action path or resource? config.yml fos_user: db_driver: orm # other valid values ...
Read more