RE: [PHP] sql question

Good day, This isn't a PHP question, but hey... This is dependant on the database platform that you're using. The suggested statement would work on MySQL. On Informix, for example, you would say 'where lit_source matches "c*" '. You should consult your database manual for more information. ============================ Darren Gamble Planner, Regional Services Shaw Cablesystems GP 630 - 3rd Avenue SW Calgary, Alberta, Canada T2P 4L4 (403) 781-4948 -----Original Message----- From: Janet Valade [mailto:jvalade1@san.rr.com] Sent: Tuesday, January 15, 2002 3:04 PM To: Wolf-Dietrich von Loeffelholz; php-general@lists.php.net Subject: Re: [PHP] sql question select * from tbl_lit where lit_source like "c%" Janet ----- Original Message ----- From: "Wolf-Dietrich von Loeffelholz" <wloeffelholz@xh9.net> To: <php-general@lists.php.net> Sent: Tuesday, January 15, 2002 12:09 PM Subject: [PHP] sql question i want that a select query display me all words beginning with an a .. like select * from tbl_lit where lit_source = 'c*' .. thnx bSue -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net