how to select data in mysql using year?

Use Following code

1. SELECT YEAR(now())

2. SELECT *
FROM `table_name`
WHERE YEAR( `start_date` ) LIKE '2007'
LIMIT 0 , 30


Most Popular

How to select first div and change data of its.

Most of the time we need to select first div that time we are just thinking what need to do. But if you think it is very simple just follow below example. Any query reply this post or comments. <head>  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js" type="text/javascript"></script>  <script type="text/javascript">  //runs once page is loaded and ready to be manipulated     $(document).ready(function(){         $('.genre').first().delegate('.album-cover','click',function() {         var str = $(this).text();                str = parseInt(str) + 1;         $(this).clone().addClass('rock').appendTo('.genre:first').html(str);         });     });      </script> </head...
Keep reading

The difference between React vs AngularJs

Image
React and AngularJs are currently using Travel and News companies. Main reason difference between AngularJs and ReactJs is AngularJS 1. AngularJs is MVC framework library. It is used for Two-way data binding. 2. AngularJs is an App development framework. ReactJS 1. React Js is a Library. It is used for One-way data binding. 2. ReactJs is an interface development framework. AngualrJs is a Javascript Framework. Where we can add HTML tags with Scrip tag. It is a Library written in Javascript. AngularJs developed by GOOGLE. AngularJs similar to Backbone or JavascriptMVC. It is a complete solution for rapid development. Following are some Features of AngularJs. 1. REST Easy: RESTful action quick communication between server to the client. 2. Extends HTML: AngularJS extends HTML with ng-directives. The ng-app directive defines an AngularJS application. The ng-model directive binds the value of HTML controls (input, select, textarea) to application data. The ng-bi...
Keep reading