[thelist] help with query Part I
Rob Agar
rob at wildlime.com
Mon Oct 31 22:16:36 CST 2005
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 !
>
More information about the thelist
mailing list