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

Tutorials Programme

Image
Loops Tutorials     Example While Loop #include <stdio.h> int main() { int count; count = 0; while (count < 4) { printf("The value of count is %d\n", count); count += 1; } return 0; } /* Result The value of count is 0 The value of count is 1 The value of count is 2 The value of count is 3 */
Keep reading

how to make virtual directory in xampp?

 C:\xampp\apache\conf\extra\httpd-vhosts.conf Add following code in end.  <VirtualHost *>     DocumentRoot "D:\www\foldername"     ServerName local.sitename         <Directory "D:\www\foldername">         Order allow,deny         Allow from all     </Directory>   </VirtualHost> C:\WINDOWS\system32\drivers\etc\hosts 127.0.0.1       local.newsite
Keep reading

ReactJs Top Hooks List

 In today article we are going to show you some reactjs hooks which can help you to increase your reactjs knowledge.  What is hooks? Hooks are a new addition in React 16.8.  It allows you to use state and other React features without writing a class. Hooks are the functions which "hook into" React state and lifecycle features from function components. Following are some hooks which are most useful for you 1. useState Hook  React useState() is a built in hooks or function which comes with React library. When you want to use “useState” you need to first import in your application using following code sample.  useState() only work with functional components. This will not work with Class components in React. Visit original article here 2. useEffect Hook The useEffect() hook allows us to run side effects on your functional components. Side effects is a general concept about how functions behave which are not predictable. A function is supposed to have side effe...
Keep reading