Re: [PHP] LIKE condition in query

BINGO! That was exactly what I needed! Thanks! Don. === "Jay Blanchard" <[EMAIL PROTECTED]> wrote in message news:003801c284fc$4fd8d2b0$8102a8c0@;000347D72515... > [snip] > $Query=" > SELECT FieldName1, FieldName2 > FROM TableName > WHERE FieldName1 LIKE '$CriterionRecord' > "; > [/S

RE: [PHP] LIKE condition in query

[snip] $Query=" SELECT FieldName1, FieldName2 FROM TableName WHERE FieldName1 LIKE '$CriterionRecord' "; [/SNIP] The LIKE criteria needs to be surrounded by wildcards... WHERE FieldName1 LIKE '%$CriterionRecord%' HTH! Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visi

Re: [PHP] LIKE condition in query

I am not up on my MS Access database sql but i would check to see if ms access supports the like condition in the where clause... On Tue, 2002-11-05 at 18:49, Don Hicks wrote: > I'm writing an SQL query in a php 4.0 script. The query pulls data from an > MS Access '97 database through an ODBC c

[PHP] LIKE condition in query

I'm writing an SQL query in a php 4.0 script. The query pulls data from an MS Access '97 database through an ODBC connection. I'm having difficulties creating a condition using "LIKE". If I write the following expression, the query works: $Query=" SELECT FieldName1, FieldName2 FROM TableName WH