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
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