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

Database backup using ssh linux

Here we are creating gz backup files using shell programming step1 . create backup file backup.sh step2. set cron job in control panel. #!/bin/bash ### MySQL Server Login Info ### MUSER="user" MPASS="Password" MHOST="localhost" MYSQL="$(which mysql)" MYSQLDUMP="$(which mysqldump)" BAK="backup/mysql" GZIP="$(which gzip)" NOW=$(date +"%d-%m-%Y") [ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/* FILE=$BAK/"databasename".gz $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS "databasename" | $GZIP -9 > $FILE
Keep reading

Css trick for jquery menu?

jquerydown.html     <script src="js/jquery-1.3.1.min.js"></script>        <script src="js/Jquerydown.js"></script>         <ul class="down">             <li><a href="#">Cars</a>                 <ul class="sub_menu">                      <li><a href="#"BMW</a></li>                      <li><a href="#">Jaguar</a></li>                      <li><a href="#">Nissan</a></li>         ...
Keep reading