Hi
I am implementimg a project where by the user enters some pattern of string ,Now I have to write a query where by the user entered string is searched or compared with a particular field in the Access Database.I have writen the following query :

$opr=$_POST["txtquery"];
$sql="select * from datadump where myfield like '$opr'";
$rs=odbc_exec($conn,$sql);

Now the query returns results only if it finds an 'exact' match ,I want to write a query where by all the records having the user entered string are returned.How do I do it??(I am using php/access)

Thankz.
Praveen

Mmmm, I use MySQL, but I bet its the same...

SELECT * FROM datadump WHERE myfield LIKE '%$opr%'

This should work if Access is the same as MySQL.

HTH,

----------
---Snib---
----------

<><

More info: The % character is a wildcard character that matches "zero or more characters". That's why the above query (with the %s) works. The query says:

Give me all the rows where the contents of myfield are "<anything>opr<anything>"

You can also use wildcards to search for things that are at the end:
  SELECT * FROM table WHERE col = '%pear tree.'

or at the beginning:
  SELECT * FROM table WHERE col = 'On the first%'



Take care,

Nik
http://www.bigaction.org/