RE: [PHP] simple search help ?
| From: | Cristian Donoso | Date: | Thu, 23 Nov 2000 21:03:30 +0000 |
| Subject: | RE: [PHP] simple search help ? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-26854@lists.php.net to get a copy of this message | ||
$letter = "A";
$sql = "SELECT * FROM table WHERE field LIKE '$letter%'";
----- Original Message -----
From: Gianni <gianni@adept.co.za>
To: <php-general@lists.php.net>
Sent: Thursday, November 23, 2000 3:54 AM
Subject: [PHP] simple search help ?
Hello
how can I search for eg. a company name in mysql by the first letter of the
company ?
eg S for Shell or F for Ford etc ect. ? I only need to search by first
letter
thanks
Gianni