← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/functions/string/comparative.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
https://launchpad.net/bugs/793182
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:
docs/functions/string/comparative.rst
1
1
Comparative Functions
2
2
=====================
3
3
 
 
4
.. _like-function:
 
5
 
4
6
LIKE            
5
7
----
6
8
 
24
26
        WHERE title LIKE 'DIRECTOR%'
25
27
        ORDER BY field, title;
26
28
 
 
29
.. _regex-function:
 
30
 
 
31
REGEX
 
32
-----
 
33
 
 
34
Undocumented.
 
35
 
 
36
.. _regexp-function:
27
37
 
28
38
REGEXP
29
39
------
54
64
 
55
65
        SELECT 'abcabc' REGEXP 'ABC', 'abcabc' REGEXP BINARY 'ABC';
56
66
 
 
67
.. _strcmp-function:
57
68
 
58
 
STRCMP()
59
 
--------
 
69
STRCMP
 
70
------
60
71
 
61
72
The purpose of STRCMP is also to compare two strings. This function returns 0 if two strings are the same, -1 if the first argument is smaller than the second according to the current sort order, and 1 otherwise.