← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Mark Atwood
  • Date: 2011-09-13 19:54:55 UTC
  • mfrom: (2397.1.3 plugin-docs)
  • Revision ID: me@mark.atwood.name-20110913195455-3bk3locm85m4jimp
merge lp:~daniel-nichter/drizzle/plugin-docs

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.