-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wednesday 23 July 2003 03:59, W. Enserink wrote: > hi all, > > > i have this table filled with names. > Does anybody know how I can write a select statement which selects all > names starting with a certain letter in the alphabet or a strane sign like > [0...9 )(*&[EMAIL PROTECTED]|?/<>,.] ??? > > any tips or help are most welcome!
Select * from <tblname> where <fldname> like 'A%'; This would select all records where <fldname> starts with "A". -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQE/HmZ1jeziQOokQnARAi+iAKCW5OkKSQ/5gG3UkeWNzfcsmuy3IwCgnd6d Mh6hxN49jKvWvp4y2BvWi5A= =1q3P -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]