Gil — Fri, 15 Dec 2000 00:44:13 +0000

It needs to be this:

Select * FROM Table WHERE Name LIKE '%$PHPSearchString%'

It's amazing what you can find when you look at documentation...

Gil — Thu, 14 Dec 2000 22:13:58 +0000

Thanks Peter. I was having some problems with that Select statement earlier but now I have it working. For what I'm doing it's fine if it picks up Johnson, Bill and Bill, Johnson. I think I was trying to do LIKE=[*$foo*] earlier...

Peter J. Boettcher — Thu, 14 Dec 2000 17:11:31 +0000

Gil,

It would be easier (and a little more efficient) if you setup the names in two separate fields (Like First_Name & Last_Name), why waste resources searching through text you don't need?

Your select statement looks pretty good, except for the fact it won't distinguish between first name & last name. So, in your example a search for the last name of Johnson could return the following recordset:

Johnson, Bill
Johnson, Steve
Smith, Johnson

Since your select statement is searching the whole field it could return a recordset like this. I would strongly recommend separating this fields, it will make life much easier. If you can't then you'll have to parse the search query and build some logic into it (ignore everything after ",").