Received: from www.base2inc.com (IDENT:root@www.base2inc.com [204.117.190.140]) by hub.org (8.9.1/8.9.1) with ESMTP id VAA29782 for ; Sun, 13 Dec 1998 21:30:53 -0500 (EST) (envelope-from fmorton@base2inc.com) Received: from tesla (tesla.base2inc.com [206.229.85.131]) by www.base2inc.com (8.8.7/8.8.7) with SMTP id VAA08245 for ; Sun, 13 Dec 1998 21:28:14 -0500 Message-ID: <010001be270b$0070f980$8355e5ce@tesla.base2inc.com> Reply-To: "Frank Morton" From: "Frank Morton" To: Subject: Newbie questions Date: Sun, 13 Dec 1998 21:39:41 -0500 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 These are probably simple questions, but I can't find the answer. A source for finding answers to this type of questions would be appreciated. Question #1 If a select might match MANY rows, how can I limit it to say 50? I thought you could do: select * from table limit 50; Question #2 In doing a select, is there a way to ignore if the case of the key? For example, if I have a table called animals with an id column and it might contain "dog" or "DOG" or "Dog" and I want to match all of them, how do I do it, with or without the "like" operator? I'd like to say: select * from animals where id='dogs' ignore case; How do I do this? Thanks you for your patience.