Re: MySQL help
| From: | Miles Thompson | Date: | Sat, 16 Dec 2000 03:22:02 +0000 |
| Subject: | Re: MySQL help | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-30646@lists.php.net to get a copy of this message | ||
Mark,
Use LIKE instead of =
MilesT
Marc Davenport wrote:
> I'm trying to query a mysql database and have it only return values that
> start with a certain letter.
> my current query setup is this
>
> $alpha_temp= $alpha . '*';
> $query="SELECT * FROM $mysql_table_member_list WHERE COMPANY='$alpha_temp'
> ORDER BY COMPANY";
>
> $alpha is just a single character, ie 'a'
> $alpha_temp was an attempt at using wild cards.
>
> Does anyone understand me?
> can anyone help?
>
> --
> 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