Re: Problem using 'Like' in SQL statements

Try using a '%' instead of an '*' - Zak ----- Original Message ----- From: "Aubrey Franklin" <aubrey.franklin@sympatico.ca> To: <php-windows@lists.php.net> Sent: Tuesday, September 19, 2000 5:35 PM Subject: [PHP-WIN] Problem using 'Like' in SQL statements > I'm running PHP on Windows 98. My Database connections so far, except > when I'm using the 'Like' SQL command (eg "select SUBJECT from COURSES > where SUBJECT Like "*Math*"). I have copied the SQL commands into my > Access database and they work fine and I have tested my query without > the 'Like' statement and it works fine in PHP. PHP just does not work > when I include the 'Like' statement. > > Can anyone out there tell what a solution would be like. Your > assistance would be greatly appreciated. > > Aubrey. > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >