From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from int-mx11.intmail.prod.int.phx2.redhat.com (int-mx11.intmail.prod.int.phx2.redhat.com [10.5.11.24]) by lists01.pubmisc.prod.ext.phx2.redhat.com (8.13.8/8.13.8) with ESMTP id s9MJdRjs025749 for ; Wed, 22 Oct 2014 15:39:27 -0400 Received: from mx1.redhat.com (ext-mx14.extmail.prod.ext.phx2.redhat.com [10.5.110.19]) by int-mx11.intmail.prod.int.phx2.redhat.com (8.14.4/8.14.4) with ESMTP id s9MJdRid000531 for ; Wed, 22 Oct 2014 15:39:27 -0400 Received: from ewr.djernes.net (ewr.djernes.net [97.107.141.189]) by mx1.redhat.com (8.14.4/8.14.4) with ESMTP id s9MJdOex009326 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 22 Oct 2014 15:39:25 -0400 Received: from portkey.lan (unknown [37.152.253.221]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by ewr.djernes.net (Postfix) with ESMTPSA id C378D2EA77 for ; Wed, 22 Oct 2014 19:39:21 +0000 (UTC) X-DKIM: Sendmail DKIM Filter v2.8.2 ewr.djernes.net C378D2EA77 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=quitelikely.com; s=2010; t=1414006762; bh=AGJpqpr2whWNwAV95ruwovtn0tNl6A+nMq4J5ks1He0=; h=Date:From:To:Subject:In-Reply-To:Message-ID:References: MIME-Version:Content-Type; b=UQFG6BuM8WIv8ZUypwY71ZFm6e66bmHBj+Pnmgjwj5krGR8f4ka/kEqrZoVFfSci+ K27jVkLIihlsdpSd1kgxrVzW9+Bk1ZKsj6sq0erCgEYhAdHVbi5s0pF3sNXIB9T3Ro pk0oH0Tl4HM6zC82YDjAd/C4xmDxNx3kCpGEqzZo= Date: Wed, 22 Oct 2014 20:39:23 +0100 (BST) From: Geoff Shang X-X-Sender: geoff@portkey.home To: Linux for blind general discussion Subject: Re: database debugging In-Reply-To: Message-ID: References: User-Agent: Alpine 2.02 (DEB 1266 2009-07-14) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-RedHat-Spam-Score: -2 (BAYES_00, DKIM_SIGNED, DKIM_VALID, DKIM_VALID_AU, SPF_PASS, URIBL_BLOCKED) X-Scanned-By: MIMEDefang 2.68 on 10.5.11.24 X-Scanned-By: MIMEDefang 2.68 on 10.5.110.19 X-loop: blinux-list@redhat.com X-BeenThere: blinux-list@redhat.com X-Mailman-Version: 2.1.12 Precedence: junk Reply-To: Linux for blind general discussion List-Id: Linux for blind general discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 Oct 2014 19:39:27 -0000 On Wed, 22 Oct 2014, Jude DaShiell wrote: > The last field in each record ought to be a number from 0-6 inclusive > followed by a );. I may have one of those numbers wrong somewhere. I was > trying to use grep to show me whatever character immediately preceeds the > ); characters and couldn't figure out anything to pass to grep for any > character that would return any results. In dos, that would just be a ?, > but that certainly doesn't work with grep. First, grep will show yu the entire line. You'd need to use something like cut or one of those other text manipulation commands to just show yu the end of the line. You could get it to show you any offending lines by piping your output to: grep -v '[0-6]);' But it would surely be easier to use a select statement to find the offending entries for you. SELECT WHERE NOT REGEXP '[0-6]$'; See http://dev.mysql.com/doc/refman/5.1/en/regexp.html (you can click through to the version appropriate for your version of MySQL). HTH, Geff.