summaryrefslogtreecommitdiff
path: root/Docs
diff options
context:
space:
mode:
authorunknown <paul@central.snake.net>2001-09-14 21:41:10 -0500
committerunknown <paul@central.snake.net>2001-09-14 21:41:10 -0500
commit76b3118cb982c2ca81699e3d9e88197b33306507 (patch)
treed98d248a4370d4f73d128297daa18480fdf091bd /Docs
parent582684500370346391c0e034661af319f1f8bb14 (diff)
downloadmariadb-git-76b3118cb982c2ca81699e3d9e88197b33306507.tar.gz
manual.texi fix example that uses INDEX() as function (there
manual.texi is no such function) Docs/manual.texi: fix example that uses INDEX() as function (there is no such function)
Diffstat (limited to 'Docs')
-rw-r--r--Docs/manual.texi2
1 files changed, 1 insertions, 1 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index 36a1757d072..b25f35f9691 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -44506,7 +44506,7 @@ By default, MySQL searches are case-insensitive (although there are
some character sets that are never case insensitive, such as @code{czech}).
That means that if you search with @code{col_name LIKE 'a%'}, you will get all
column values that start with @code{A} or @code{a}. If you want to make this
-search case-sensitive, use something like @code{INDEX(col_name, "A")=0} to
+search case-sensitive, use something like @code{INSTR(col_name, "A")=1} to
check a prefix. Or use @code{STRCMP(col_name, "A") = 0} if the column value
must be exactly @code{"A"}.