I think you want to use REGEXP rather than LIKE:
create table blah(name varchar(10));
insert into blah (name) values ('adam');
insert into blah(name) values ('bill');
insert into blah(name) values('erin');
select * from blah where name regexp '^[aeiou]';
I don't know why LIKE doesn't work similarly -- perhaps for performance
reasons.
Cheers
Kerry
On Fri, Aug 6, 2010 at 4:25 AM, vicenrico <[email protected]> wrote:
> Hello. I'm a spanish developer with a serious problem ( at least for
> me :-D ).
> How can this sentence work in h2 database?
>
> SELECT *
> FROM Customers
> WHERE Name LIKE '[aeiou]%'
>
>
> What i mean i that i can't do this with h2database. I want to show all
> customers beginning their names with a vowel.
> In real SQL i can do that, but not with h2database.
>
> Can anybody help me??
>
> Thanks!!!
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<h2-database%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
