On 6/17/2011 5:36 PM, Sven Utcke wrote: >I might see a name > like "image 1 (modified%20(2)).jpg". Since I can not forsee which > parts might have been encoded and which not, I therefore need to write > something like: > > SELECT * FROM table WHERE urldecode(table.name)='some file name'; > > So I guess my question is: is there such a function "urldecode()"
No. > and > if not, what is the best way to solve this problem? http://sqlite.org/c3ref/create_function.html > Can I define my > own functions in sqlite3? Yes you can. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
