On 1/12/2011 4:42 PM, Bruno Augusto wrote: > So, it would be: > > SELECT `Application`, `Class`, `Method`, `RequiredParams`, `OptionalParams` > FROM `Routes` WHERE `RequestMethod` = "GET" AND "/" LIKE `URI` > > As "GET" is the default Request Method, and the string I'm passing is a > single slash. > > If so, I didn't receive any result when, if I use PHP preg_match() function, > I receive a match of the first Regular Expression: /(.*?)
REGEXP and LIKE have different pattern syntax. You mant '/' REGEXP URI assuming you have an appropriate custom function registered with SQLite. Where does /(.*?) come from? In the image you referenced a couple posts back, nothing like that appeared. > Igor Tandetnik said it's not needed the slashes, because they are > delimiters. No, I said the opposite: I thought you were using slashes as delimiters, and pointed out that they are *not* treated as such. Now I understand that you want to match slashes literally. This is what happens out of the box; just ignore that part of the discussion. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
