Entry

how can i select the records where the First Letter is 'D' from the database?

Feb 13th, 2008 00:22
dman, Mattias Westberg, Marc Tomlinson, http://sturly.com

Use the LIKE command. Eg: SELECT * FROM user WHERE firstname LIKE "D%";

"user" is the table and "firstnamn" the column