Hi guys,
I was wondering if anyone knew of a paramter that can be put on the end of a
select statement when querying a table which only pulled out one unique
record based on a field.
I.e
If i had a drink database and in it were 10 cokes 10 fantas 10 pepsi's what
select statement would i need to
Andrew,
Wednesday, October 16, 2002, 11:01:05 AM, you wrote:
AW I was wondering if anyone knew of a paramter that can be put on the end of a
AW select statement when querying a table which only pulled out one unique
AW record based on a field.
AW I.e
AW If i had a drink database and in it were
* Andrew Wilson
Hi guys,
I was wondering if anyone knew of a paramter that can be put on
the end of a
select statement when querying a table which only pulled out one unique
record based on a field.
... LIMIT 1
I.e
If i had a drink database and in it were 10 cokes 10 fantas 10
ESCAPE
Mite help...?
Simon
MySQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To