In the following drupal table 'webform_submitted_data' the date
12/8/2007 is specified via 3 records ie:
2 1176718828 0 12
2 1176718828 1 8
2 1176718828 2 2007
I need to be able to select a sid that value matches a certain date.
In the above example the sid value would be '2' if I wanted to select
with date '12/8/2007'. I was wondering if there was a mysql (4.1.21-
standard) SQL statement I could use select all the distinct sid values
that match a certain date. The following is an example of a
'webform_submitted_data' table:
sid cid no data
2 1176015743 0
alison@mailaby.com
2 1176015500 0 alison
2 1176015691 0 money
2 1176718828 0 12
2 1176718828 1 18
2 1176718828 2 2007
2 1176851105 0 1
2 1176851105 1 8
2 1176851105 2 2008
2 1177590862 0 Cheapest flights please 7 adt 6 chd
3 1176015743 0 ijwuishwe@mnqashiu
3 1176015500 0 james
3 1176015691 0 hogh
3 1176718828 0 4
3 1176718828 1 5
3 1176718828 2 2008
3 1176851105 0 4
3 1176851105 1 26
3 1176851105 2 2008
3 1177590862 0 Cheapest easter seats please
4 1176015743 0 jasnbuighe@kjnasiuh
4 1176015500 0 david
4 1176015691 0 wings
4 1176718828 0 12
4 1176718828 1 8
4 1176718828 2 2007
4 1176851105 0 12
This is a drupal table and I would prefer not modify the structure of
it.