Changes

User:Minooz/NexJ/database

117 bytes removed, 11:17, 15 November 2010

→‎PostgreSQL and MySQL

<code>

mysql> SELECT filename FROM t1;

~~+--------------+~~| filename |~~+--------------+~~| : C: || C:\ | | C:\Programs || C:\Programs\ |~~+--------------+~~</cpde>

To test for values that end with backslash, you can match the values using either of the following patterns:

<code>

mysql> SELECT filename, filename LIKE '%\\' FROM t1;

~~+--------------+---------------------+~~| filename | filename LIKE '%\\' |

+--------------+---------------------+

| C: | 0 |

1

edit