Questions involving sql queries

[aquatsr]

So I have a table called books and I want to select all titles that start with 'a' or 'A' how do I do such a thing? Also how would I do that for titles starting with numbers (any number)?thx.

[murfitUK]

Use the wildcard in your select egSELECT titles FROM books WHERE titles LIKE 'A%'Have a look at sqlcourse.com

[aquatsr]

Use the wildcard in your select egSELECT titles FROM books WHERE titles LIKE 'A%'Have a look at sqlcourse.com

Thank you. I had forgotten about that (I'm still new to sql queries).

[aquatsr]

So I have a table called books and I want to select all titles that start with numbers (any number)?thx.