Query Where Begins With...
Moderator: General Moderators
Query Where Begins With...
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?
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England
Code: Select all
SELECT * FROM words WHERE word LIKE 'A%';