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 get table count for all tables in a database in Mysql?

Following Example shows you how to get tables list from database using PHP CODE. <?php $dbname = 'mysql_dbname'; if (!mysql_connect('localhost', 'root', '')) {     echo 'Could not connect to mysql';     exit; } $sql = "SHOW TABLES FROM $dbname";$result = mysql_query($sql); if (!$result) {     echo "DB Error, could not list tables\n";     echo 'MySQL Error: ' . mysql_error();     exit; } while ($row = mysql_fetch_row($result)) {     echo "Table: $row[0] \n"; } mysql_free_result($result);?>
Keep reading