I have tried that and I don't get an error, but I don't get any records
returned either. And I have lowered the search string like you
mentioned. Here's what I tried ( Access syntax ):
SELECT autoQuesID,fldQuesTitle,fldBody
FROM tblFAQ_Question
WHERE LCase(fldBody) LIKE '%$strSearchFor%';
Nic
Have you tried lowering the fldBody as well? Like:
SELECT autoQuesID,fldQuesTitle,fldBody
FROM tblFAQ_Question
WHERE LOWER(fldBody) LIKE '%$strSearchFor%';
And $strSearchFor has already been lowered, of course.
--Nicole
---
Nicole Swan
Web Programming Specialist
Carroll C
Hi Barry--
First, I want to see if I understand what you mean, then I'll take a shot
at some SQL to solve the problem.
I take it you have two tables, "a" and "b". They may look something like
this:
Table: a
id name
--- --
001 Bob
002 Ted
003 Mary
004 S
Sweet!!
Many thanks!
Russ
#---#
"Believe nothing - consider everything"
"Web Developers do it on-the-fly."
Russ Michell
A
Russ Michell wrote:
>
> Hi there folks, I have a small prob regarding SQL on MySQL 3.22.32
> using php4.0.3pl1 :
>
> I want to select DISTINCT sports from one table WHERE a username and a
> password match a username and a password in another table - not sure
> how to construct my query.
>
> In