Re: [sqlite] select only records with fields that BEGIN with a certain sub-string

Again, thank you for your advice. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select only records with fields that BEGIN with a certain sub-string

On Thu, 26 Dec 2013 11:59:10 +, dean gwilliam wrote: >Thank you all for your helpful advice. An alternative is PRAGMA table_info(yourtable); http://sqlite.org/pragma.html#pragma_table_info It resturns a result set, one row per column in yourtable. -- Groet,

Re: [sqlite] select only records with fields that BEGIN with a certain sub-string

Thank you all for your helpful advice. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select only records with fields that BEGIN with a certain sub-string

This is actually awesome to know, thanks Stephen, I always thought at least 1 step is needed - I'm going to immediately implement this in some functions! On 2013/12/26 13:30, Stephan Beal wrote: There are probably a few approaches that would work, but I can think of none quicker/more

Re: [sqlite] select only records with fields that BEGIN with a certain sub-string

On Thu, Dec 26, 2013 at 12:21 PM, RSmith wrote: > There are probably a few approaches that would work, but I can think of > none quicker/more efficient than maintaining a list of column names > ("SELECT * from t WHERE 1 LIMIT 1" will produce it real quick) If you want JUST

Re: [sqlite] select only records with fields that BEGIN with a certain sub-string

On Dec 26, 2013, at 11:49 AM, dean gwilliam wrote: > ...is this possible or should I return the whole lot and subject it to a > regexp filter to get my cut-down list? http://www.sqlite.org/lang_expr.html#like ___

[sqlite] select only records with fields that BEGIN with a certain sub-string

...is this possible or should I return the whole lot and subject it to a regexp filter to get my cut-down list? Any advice much appreciated and BTWmerry Christmas to you all! ___ sqlite-users mailing list sqlite-users@sqlite.org