shion I also need to offer the ability for them to untagg all
members found. So I'd need to do a select based on the found ID and delete
all rows that were returned.
I'm doing this now in PHP using multiple SQL calls but when I get into the
1,000 of members it's taking longer t
t(5) unsigned | | | 0 |
|
| member_id_editor | smallint(5) unsigned | | | 0 |
|
| updatehistory_details | text | | | |
|
+----+--+--+-+-+
> - Original Message -
> From: "
AND member.member_id = updatehistory.member_id_editor
ORDER BY email.email_address;
How would I get the emails for every member who does NOT have a row in
updatehistory?
~ Mike
-
Mike Zornek
Web Designer, Media Developer, Programmer and Geek
Personal site: <http://MikeZornek.com>
--
MySQL Gen
| MUL | 0 |
|
++---+--+-+-+---
-+
How would I select all distinct member_id that have a specialty_id of 6 and
33?
Thanks!
~ Mike
-
Mike Zornek
Web Designer, Media Developer, Programmer and Geek
Personal s
a column which will be sorted when the user asks
for "random" results.
Thanks for you help.
~ Mike
-
Mike Zornek
Web Designer, Media Developer, Programmer and Geek
Personal site: <http://MikeZornek.com>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ollow-up question:
I've had a lot of trouble with RAND() on my MySQL 3 box not being all that
random. This time I'm using 4.0.17-log. Is it going to be any better?
~ Mike
-
Mike Zornek
Web Designer, Media Developer, Programmer and Geek
Personal site: <http://MikeZornek.com
I'm timing it at
225 seconds but this machine is faster than server.
Is there a simpler / faster SQL query I could use?
Thanks!
~ Mike
-
Mike Zornek
Web Designer, Media Developer, Programmer and Geek
Personal site: <http://MikeZornek.com>
--
MySQL General Mailing List
For list a
= 'MI' order by
rand()
When I run this on MySQL 3.23.54-log I get 78 rows, with many dups. When I
move the DB to MySQL 4.0.18-standard and run the query I get 21 rows, no
dups.
Is this a known bug? Is there any work around, besides upgrading (which is
planned but not immediately).
Tha
