in reply to (jeffa) Re: mysql search statement
in thread mysql search statement

the problem is not creating the statement. It's making mysql not accept '' as an actual value. I want blanks to be ignored.

Replies are listed 'Best First'.
Re: Re: (jeffa) Re: mysql search statement
by talexb (Chancellor) on Dec 31, 2001 at 02:12 UTC
    I'd suggest modifying that column to be NOT NULL .. that way the database will refuse to accept '' as a valid value.

    --t. alex

    "Excellent. Release the hounds." -- Monty Burns.