Page 1 of 1

Query Where Begins With...

Posted: Mon Nov 29, 2004 12:50 pm
by AliasBDI
I have a small dictionary type database where I need a page that lists the words according to their first letter. So when someone clicks on the letter "B" it queries the database for records that begin with "b". What would this query look like?

Posted: Mon Nov 29, 2004 1:52 pm
by kettle_drum

Code: Select all

SELECT * FROM words WHERE word LIKE 'A%';

Posted: Mon Nov 29, 2004 2:35 pm
by AliasBDI
worked great, thanks!