Likes Received By mwasif

  1. tflight liked mwasif's post in the thread MySQL Query Finding rows since last [day of week].

    SELECT * FROM table WHERE timestamp_field >= CAST( CONCAT( DATE_SUB(CURDATE(), INTERVAL WEEKDAY(CURDATE()-5) DAY), ' 00:00:00') AS...

    Apr 21, 2008

  2. ruby90 liked mwasif's post in the thread How do I find out if there's any duplicate records in a table?.

    There is no need to use COUNT() twice SELECT name, COUNT(*) cnt FROM authors GROUP BY name HAVING cnt>1

    Apr 20, 2008

  3. indyonline liked mwasif's post in the thread how do i access database?.

    Where you are setting up this script? On you local machine or on web hosting account? If you are on local machine then use any MySQL...

    Mar 30, 2008
Page 2 of 2