Select statement paramter

2002-10-16 Thread 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. 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

re: Select statement paramter

2002-10-16 Thread Victoria Reznichenko
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

Re: Select statement paramter

2002-10-16 Thread Roger Baklund
* 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

RE: Select statement paramter

2002-10-16 Thread Simon Green
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