Re: (jeffa) Re: 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.

Comment on Re: (jeffa) Re: mysql search statement

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.	[reply]