← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Clint Byrum
  • Date: 2011-03-03 01:55:10 UTC
  • mto: (2222.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 2223.
  • Revision ID: clint@ubuntu.com-20110303015510-fj9fsdimwyo2gefy
Adding regex_policy plugin for detailed authorization specifiction

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/functions/string/comparative.rst
6
6
 
7
7
The LIKE operator is used to check if field values match a specified pattern, and searches for less-than-exact but similar values.
8
8
 
 
9
An initial example is:
 
10
 
 
11
.. code-block:: mysql
 
12
 
 
13
        SELECT 'ä' LIKE 'ae' COLLATE latin1_german2_ci;
 
14
 
 
15
Returns 0
 
16
 
 
17
Whereas:
 
18
 
 
19
.. code-block:: mysql
 
20
 
 
21
        SELECT 'ä' = 'ae' COLLATE latin1_german2_ci;
 
22
 
 
23
Returns 1
 
24
 
9
25
The LIKE operator supports the use of two wildcards. (Wildcards provide more flexibility by allowing any character or group of characters in a string to be acceptable as a match for another string):
10
26
 
11
27
    * Percentage (%): Represents zero or more values.