Hi all,
how can I escape the '%' in where clause?
For example:
*CREATE TABLE tbl (*
* field varchar(30)*
*);
INSERT INTO tbl VALUES ('first_prefix%text');
**INSERT INTO tbl VALUES ('second_prefixSEPARATORtext');
**INSERT INTO tbl VALUES ('third_prefix%text');
**INSERT INTO tbl VALUES ('third_prefix%something');*
Now I want to select each rows, that contains <any prefix> foolowed by
string '%text'.
I suggested the query may look like this:
*SELECT * from tbl where field LIKE '%\%text';
*and expected result is:
*
first_prefix**%text**
third_prefix%text
*
But SQlite does not understand the backslash character as escape
character, but it is a valid char.
Have you any ideas?
Thanks,
Palo
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
