select by certain letter

[blackwinged]

Hi!

What I want to do is to SELECT all rows in a table where column "name" values begin with a certain letter, e.g. 'D' .

Should sound somethin like this: "SELECT * FROM table1 WHERE name starts_with 'b'";

thanks 😉

[barand]

"SELECT * FROM table1 WHERE name LIKE 'b%' ";

[blackwinged]

thanks! that's it :-D