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

The Requested Url /Phpmyadmin/ Was Not Found On This Server

Image
  What Is phpMyAdmin phpMyAdmin is an open-source software tool introduced on September 9, 1998, which is written in PHP. Basically, it is a third-party tool to manage the tables and data inside the database. phpMyAdmin supports various type of operations on MariaDB and MySQL. The main purpose of phpMyAdmin is to handle the administration of MySQL over the web. phpMyAdmin has a GUI application which used to mange the database. Here we can create a database, table and execution of mysql query using phpMyAdmin GUI Our Problem  : phpMyAdmin url not found. Here you will find the  Solution Here
Keep reading