MySQL like

[Honza Pazdziora]

On Sun, Mar 19, 2000 at 01:21:28PM +0100, Zdeněk Mazanec wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Zdravim,
>  hledam, hledam a nemohu nalezt. Opravdu se v MySQL neda kounstrukci
> select ... where sloupec like "%<neco>%" rict, aby se nebral ohled na
> velikost pismen v retezci <neco>?

	where upper(sloupec) like upper('%neco%')

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
   .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, MTB, Spain.
I just returned from my vacation and started cleaning my mailbox -- sorry
if this message reaches you late.