[thelist] help with query Part I

Rob Agar rob at wildlime.com
Mon Oct 31 22:21:38 CST 2005


or more accurately 

	WHERE mls LIKE '06%' 


> -----Original Message-----
> From: thelist-bounces at lists.evolt.org 
> [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Rob Agar
> Sent: Tuesday, 1 November 2005 2:17 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] help with query Part I	
> 
> 
> hullo
> 
> something along these lines perhaps:
> 
> 	WHERE column LIKE '06%'
> 
> hth
> Rob
> 
> > -----Original Message-----
> > From: thelist-bounces at lists.evolt.org 
> > [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Casey
> > Sent: Tuesday, 1 November 2005 2:04 PM
> > To: The List
> > Subject: [thelist] help with query Part I
> > 
> > 
> > Hello!  Happy Halloween to everyone..
> > 
> > OK, the db in question had a column called mls containing an 
> > id.  All id's 
> > in this column start with a 0... some are 07xxxx, some are 
> > 06xx, etc.  There 
> > is no set number of total digits.  I need to select only the 
> > rows where mls 
> > starts with 06.
> > 
> > How would such a where clause be formatted?
> > 
> > TIA!!! 
> > 
> > -- 
> > 
> > * * Please support the community that supports you.  * *
> > http://evolt.org/help_support_evolt/
> > 
> > For unsubscribe and other options, including the Tip Harvester 
> > and archives of thelist go to: http://lists.evolt.org 
> > Workers of the Web, evolt ! 
> > 
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 




More information about the thelist mailing list