Write a query with "like" statement

Question

I want to write a query that selects items that their titles are starting with an alphabet, something like:

select * from items where title like "A%";

But some of item names are starting with "A or 'A and I want to know if it's possible so my query contain all those forms of titles.

Answer 1

Or you can use regexp if there are to many possibilities to OR them.

Answer 2

select * from items where title like 'A%' or title like '\'A%';