>Description:
There is in manual_Problems.html:
That means that if you search with col_name LIKE 'a%', you will get all
column values that start with A or a. If you want to make this search
case-sensitive, use something like INDEX(col_name, "A")=0 to check a
prefix. Or use STRCMP(col_name, "A") = 0 if the column value must be
exactly "A".
But there is no function INDEX in mysql.
>How-To-Repeat:
See manual_Problems.html
>Fix:
There should be something like LOCATE("A", col_name)=1.
>Submitter-Id: <submitter ID>
>Originator: Hans Ginzel
>Organization:
MFF UK
http://www.matfyz.cz/hans/
>
>MySQL support: none
>Synopsis: There is no function INDEX used in example in manual
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: doc-bug
>Release: mysql-3.23.36 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i586
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.36
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 1 hour 11 min 0 sec
Threads: 2 Questions: 86 Slow queries: 2 Opens: 18 Flush tables: 1 Open tables:
12 Queries per second avg: 0.020
>Environment:
Debian Linux Woody
System: Linux geze 2.2.19-iiide #2 SMP Mon May 21 09:31:10 CEST 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20010319 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++'
CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 kvě 27 19:46 /lib/libc.so.5 ->
libc.so.5.4.46
-rw-r--r-- 1 root root 589460 bře 19 14:47 /lib/libc.so.5.4.46
lrwxrwxrwx 1 root root 13 srp 20 22:36 /lib/libc.so.6 -> libc-2.2.3.so
-rwxr-xr-x 1 root root 1155720 čec 27 22:42 /lib/libc-2.2.3.so
-rw-r--r-- 1 root root 2579358 čec 25 17:15 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 čec 25 17:15 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler
--with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid
--without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock
--with-mysqld-user=mysql --without-bench --with-extra-charsets=all
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
