RE: [PHP-WIN] Need SQL Help for PHP_WIN and ODBC/Access !! SOLVED
| From: | Williams, Dewey | Date: | Mon, 07 Oct 2002 20:07:35 +0000 |
| Subject: | RE: [PHP-WIN] Need SQL Help for PHP_WIN and ODBC/Access !! SOLVED | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-16231@lists.php.net to get a copy of this message | ||
It seems the use of LIKE in an sql statement requires the 'wild-card' %
instead of * when sending to an Access (and other?) databases. If anyone
knows WHY, I would like an explanation.
Dewey Williams
williams@email.uncc.edu
-----Original Message-----
From: Williams, Dewey [mailto:williams@email.uncc.edu]
Sent: Thursday, October 03, 2002 3:59 PM
To: php-windows@lists.php.net
Subject: [PHP-WIN] Need SQL Help for PHP_WIN and ODBC/Access
HELP!
I need the WHERE statement to use LIKE and wrap the variable $ProdVar in *
so users can do a text search on the field.