On 12 Jan 2011, at 9:14pm, Bruno Augusto wrote: > When querying, I will NOT pass the Regular Expression, I will pass the > string to be used as target for the stored patterns.
The previous responses were fine. Operators take more than one operand, and you will need to specify all of them each time you use the operator. Each operand can be specified in the SELECT command, or a reference to a column in the TABLE you're SELECTing from. So if you choose to use, for example, LIKE you might do SELECT * FROM myTable WHERE filename LIKE 'x_.com' but you might instead do SELECT * FROM myTable WHERE 'x2.com' LIKE pattern One matches a supplied pattern with all values stored in the TABLE, the other checks a supplied value against all the patterns stored in the TABLE. The second of these is what you asked for, I think. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
