select based letter

[Sebastian]

i have a text field column and i want to select the rows based on the 
first letter in this column, eg:

---------
| topics |
---------
Motherboard
Hard Drives
Memory
Video Cards
Monitors
i want to select all the rows that begin with the letter M (Motherboard, 
Memory, Monitors)
any suggestions?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]