Hi, I'm having trouble with the percent character .....
By example in my table I have : id name 1 micka 2 mickael I would like to do that : Select * from table name where name LIKE '%micka%' with my linux c program, the result is 0 but with the sqlite3 command program it works .... I also tested this : Select * from table name where name LIKE 'micka%' and this time, it works in my linux c program ... I'm using the last package of sqlite3-dev ... https://packages.debian.org/wheezy/sqlite3 Why ? Thx you ! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users