Get rows where lastLoginTimestamp is in last 7 days
The values seem to be Unix timestamps, stored as strings. You can use the special datetime functions that MySQL has for conversions:

SELECT * 
FROM representative 
WHERE DATE_ADD(FROM_UNIXTIME(lastLoginTimestamp), INTERVAL 7 DAY) &gt;= NOW() ;


but it won't be very good for efficiency. Much more efficient, if there is an index on the column, to do it the other way around:  

(we assume that the values in the columns are CHAR(10). If some values have smaller length, you'll get erroneous results.)

SELECT * 
FROM representative 
WHERE lastLoginTimestamp 
      &gt;= CAST(UNIX_TIMESTAMP(NOW() - INTERVAL 7 DAY) AS CHAR(10));


The above condition if you want all rows, starting from exactly 7 days ago, same time as now. If you want rows starting from 6 days ago at midnight, so previous 6 days + today (whatever that is, a few minutes or 23 hours, 59 mins):

SELECT * 
FROM representative 
WHERE lastLoginTimestamp 
      &gt;= CAST(UNIX_TIMESTAMP(CURRENT_DATE - INTERVAL 6 DAY) AS CHAR(10));