mysql select checking for null characters

**ScarletPimpernal** · Apr 27 '07, 04:17 AM

Hi,

The Syntax for the query is wrong:

Use the Below query,

SELECT TITLE, FNMI, SALUTATION, COMPANY, E_MAIL FROM DBASE WHERE BOARD IS NOT NULL OR CBM IS NOT NULL OR LEGIS IS NOT NULL;

There can't be Comma seperator in the query, i mean in the where clause of the query.

Thanks,
Scarlet

Originally posted by tolkienarda

hi all
i dynamicaly generate a select statement and there seems to be a problem with it.
below is an example of one that is generated

Code:

SELECT TITLE, FNMI, SALUTATION, COMPANY, E_MAIL FROM DBASE WHERE BOARD IS NOT NULL, OR CBM IS NOT NULL, OR LEGIS IS NOT NULL

when i paste it into the sql part of phpmyadmin i get the following error

Code:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' OR CBM IS NOT NULL , OR LEGIS IS NOT NULL  LIMIT 0, 30' at line 1

all of the capital letters are because someone made this database in microsoft access, and she apparently likes caps. I have never used 'OR' or IS NOT NULL in my select statements before and maybe there is somthing wrong with that syntax

i would love some help

eric

**tolkienarda** · Apr 27 '07, 03:51 PM

perfect thanks a million

eric

mysql select checking for null characters

mysql select checking for null characters

Comment

Comment