Unterschied von LIKE und RLIKE

[Sebastian Mendel]

Technik via echtwahr.com - Neuer Server schrieb:
> Hi,
> 
> 
>  > SELECT * FROM tbl WHERE fl_30 RLIKE 'wort'
>  > weniger bzw. eine andere Trefferanzahl hat als
>  > SELECT * FROM tbl WHERE fl_30 LIKE '%wort%'
>  > die Doku bringt mich da nicht weiter.
> 
> Aus der MySQL 4.1 Doku
> 
> expr REGEXP pat
> expr RLIKE pat
> Performs a pattern match of a string expression expr against a pattern pat.
> The pattern can be an extended regular expression. The syntax for regular
> expressions is discussed in section G MySQL Regular Expressions. Returns 1
> if expr matches pat, otherwise returns 0. If either expr or pat is NULL, the
> result is NULL. RLIKE is a synonym for REGEXP, provided for mSQL
> compatibility. Note: Because MySQL uses the C escape syntax in strings (for
> example, `\n' to represent newline), you must double any `\' that you use in
> your REGEXP strings. As of MySQL 3.23.4, REGEXP is not case sensitive for
> normal (not binary) strings.
> ...
> REGEXP and RLIKE use the current character set (ISO-8859-1 Latin1 by
> default) when deciding the type of a character. However, these operators are
> not multi-byte safe.
> 
> Das kann es eventuell sein:
> REGEXP is not case sensitive for normal (not binary) strings.

LIKE auch nicht


-- 
Sebastian Mendel

www.sebastianmendel.de
www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet

-- 
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql