← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Mark Atwood
  • Date: 2011-09-15 18:05:14 UTC
  • mfrom: (2414.5.3 update-docs)
  • Revision ID: me@mark.atwood.name-20110915180514-vii49ka3heb7gbkw
merge lp:~vjsamuel/drizzle/more-doc-fixes

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/functions/string/position.rst
35
35
 
36
36
Return the index position of the first argument within the second argument
37
37
 
 
38
.. code-block:: mysql
 
39
 
 
40
        SELECT FIND_IN_SET('2', '1,2,3,4');
 
41
                -> 2
 
42
        SELECT FIND_IN_SET('1', '123');
 
43
                -> 0
 
44
                
38
45
.. _instr-function:
39
46
 
40
47
INSTR
45
52
.. code-block:: mysql
46
53
 
47
54
        SELECT INSTR('tacosalad', 'salad');
48
 
                -> 4
 
55
                -> 5
49
56
        SELECT INSTR('burger', 'salad');
50
57
                -> 0
51
58
 
56
63
 
57
64
Return the leftmost number of characters as specified
58
65
 
 
66
.. code-block:: mysql
 
67
 
 
68
        SELECT LEFT('drizzled', 7);
 
69
                -> 'drizzle'
 
70
 
59
71
.. _insert-function:
60
72
 
61
73
INSERT
87
99
 
88
100
Return the position of the first occurrence of substring.
89
101
 
 
102
.. code-block:: mysql
 
103
 
 
104
        SELECT LOCATE('salad', 'tacosalad');
 
105
                -> 5
 
106
        SELECT LOCATE('burger', 'salad');
 
107
                -> 0
 
108
 
90
109
.. _position-function:
91
110
 
92
111
POSITION