You can use MySQL's inbuilt function TIMESTAMPDIFF to get difference between two dates in MySQL. A typical query would be
sql
MySQL query with the conditions as ‘NOT LIKE IN’
While working with MySQL database i needed to write a query which will exclude rows where a column contains one or more words from a set of words. i.e I want to fetch data from student from table where name doesn't contain words shashank,john etc. Initially i was trying to write a query like this : … Continue reading MySQL query with the conditions as ‘NOT LIKE IN’