~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/functions/string/position.rst

  • Committer: Daniel Nichter
  • Date: 2011-08-13 20:41:38 UTC
  • mto: This revision was merged to the branch mainline in revision 2413.
  • Revision ID: daniel@percona.com-20110813204138-stxa89ca1t7cg1uy
Skeleton documentation for all plugins, more complete docu for first half of plugins.
Clean up plugin.ini titles and descriptions.
Reformat and reorganize root index.
Change Administrative to Administration and remove empty files (logging, etc.)
Add, fix, and tag documentation for functions.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
Position Functions
2
2
==================
3
3
 
 
4
.. _field-function:
 
5
 
4
6
FIELD
5
7
-----
6
8
 
26
28
 
27
29
Returns 0
28
30
 
 
31
.. _find-in-set-function:
 
32
 
29
33
FIND_IN_SET
30
34
-----------
31
35
 
32
36
Return the index position of the first argument within the second argument
33
37
 
 
38
.. _instr-function:
 
39
 
34
40
INSTR
35
41
-----
36
42
 
43
49
        SELECT INSTR('burger', 'salad');
44
50
                -> 0
45
51
 
 
52
.. _left-function:
 
53
 
46
54
LEFT
47
55
----
48
56
 
49
57
Return the leftmost number of characters as specified
50
58
 
 
59
.. _insert-function:
 
60
 
51
61
INSERT
52
62
------
53
63
 
70
80
        SELECT INSERT('Aquatic', 3, 100, 'This');
71
81
                -> 'AqThis'
72
82
 
 
83
.. _locate-function:
73
84
 
74
85
LOCATE
75
86
------
76
87
 
77
88
Return the position of the first occurrence of substring.
78
89
 
 
90
.. _position-function:
 
91
 
79
92
POSITION
80
93
--------
81
94
 
82
95
A synonym for LOCATE()
83