Article View: pl.comp.lang.php
Article #1443Re: select zaczynajace sie na litery
From: Piotr Burda
Date: Tue, 28 Aug 2001 13:08
Date: Tue, 28 Aug 2001 13:08
14 lines
1178 bytes
1178 bytes
> SELECT > nazwa > FROM > miejscowosci > WHERE > (LOWER(nazwa) REGEXP '^[abcćdef].*') > ORDER BY nazwa > > > P.S. Jeśli ktoś zna wydajniejszy sposób to proszę o korektę. > > slawek- czy ta metoda znacznie wplynie na wydajnosc? Piotr
Technical Details
Message-ID:
<9mg536$ntj$1@news.tpi.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!news.man.torun.pl!news.icm.edu.pl!newsfeed.tpinternet.pl!news.tpi.pl!not-for-mailReferences:
<9mg3p5$fd0$1@news.tpi.pl> <3b8b96dd@news.home.net.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!news.man.torun.pl!news.icm.edu.pl!newsfeed.tpinternet.pl!news.tpi.pl!not-for-mail From: "Piotr Burda" <poczta@narty.pl> Newsgroups: pl.comp.lang.php Subject: Re: select zaczynajace sie na litery Date: Tue, 28 Aug 2001 15:08:53 +0200 Organization: tp.internet - http://www.tpi.pl Lines: 16 Message-ID: <9mg536$ntj$1@news.tpi.pl> References: <9mg3p5$fd0$1@news.tpi.pl> <3b8b96dd@news.home.net.pl> NNTP-Posting-Host: 195.205.21.185 X-Trace: news.tpi.pl 999004070 24499 195.205.21.185 (28 Aug 2001 13:07:50 GMT) X-Complaints-To: usenet@tpi.pl NNTP-Posting-Date: 28 Aug 2001 13:07:50 GMT X-Newsreader: Microsoft Outlook Express 5.00.2919.6700 X-MSMail-Priority: Normal X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit