[yunqa.de] Re: Regular expression in select
- From: Delphi Inspiration <delphi@xxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Thu, 16 Jun 2011 17:40:53 +0200
On 16.06.2011 16:55, D H wrote:
> I'm using SQLiteSpy. It is a great tool !
>
> I know that in the where clause I can use a regular expression.
>
> Is it also possible to use a regular expression in the select clause, in
> order to get only a part of a long string?
> If possible, could you give a small example
create table t (a);
insert into t values ('one');
insert into t values ('two');
insert into t values ('three');
select * from t where a regexp '^t.*'
Ralf
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa
Other related posts:
