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 un

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 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