g [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Schrum, Allan
> Sent: Tuesday, March 02, 2010 12:50 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] why is underscore like dash?
>
>
> Perhaps because underscore is considered to be a wild-card se
sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Wilson, Ronald
> Sent: Tuesday, March 02, 2010 10:41 AM
> To: General Discussion of SQLite Database
> Subject: [sqlite] why is underscore like dash?
>
> This test was performed on Windows XP:
On Tue, Mar 2, 2010 at 9:41 AM, Wilson, Ronald wrote:
> sqlite> select * from test where text like '_';
from http://www.sqlite.org/lang_expr.html
> An underscore ("_") in the LIKE pattern matches any single character in the
> string.
___
sqlite-users m
> This test was performed on Windows XP:
>
> PS C:\Documents and Settings\ma088024> sqlite3
> SQLite version 3.6.22
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> create table test (text);
> sqlite> insert into test values('_');
> sqlite> insert into test v
>sqlite> select * from test where text like '_';
Underscore '_' is LIKE wildcard for any single character, percent '%'
matches any substring.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlit
This test was performed on Windows XP:
PS C:\Documents and Settings\ma088024> sqlite3
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table test (text);
sqlite> insert into test values('_');
sqlite> insert into test values('-');
sqlite
6 matches
Mail list logo