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 )(*&^%$#@!_+{}][\|?/<>,.] ???

any tips or help are most welcome!

Regards
Wilbert Enserink
--------------
mysql,select

-------------------------
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http://www.pdd.nl
info (AT) pdd (DOT) nl
-------------------------

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 23 July 2003 03:59, W. Enserink wrote:
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/mysql?unsub=m...ie.nctu.edu.tw