SQL Search issue

[NZ_Kiwis]

I've got a MySQL DB which has a Unix timestamp in it... i want to get the records for one day... IE: Wednesday May 2nd...

How can I do this?

[Installer]

This should work:

$find = 'Wednesday May 2nd';
$query = "SELECT uts_field FROM my_table 
          WHERE FROM_UNIXTIME(uts_field, '%W %M %e%D') = " . $find;

MySQL Date and Time Functions

[NZ_Kiwis]

Cool, what if I wanted to group by day?

[Installer]

I don't know for sure; maybe like this:

$find = 'Wednesday May 2nd';
$query = "SELECT uts_field, FROM_UNIXTIME(uts_field, '%W %M %e%D') AS group_by FROM my_table 
          WHERE FROM_UNIXTIME(uts_field, '%W %M %e%D') = " . $find . "
          GROUP BY group_by";

(I'm getting this from the manual as I go along.)

[NZ_Kiwis]

but I don't want to set $find... i want it to group everything in the db

[Installer]

Then just leave out the where clause...