katlees
asked on
Records with field not null
I have this code SELECT * FROM Events WHERE CornPalace='1' AND APPROVED='1' ORDER BY RAND() Limit 5 - how do I get it to only pull up the records where Image3FileName is not empty?
SELECT *
FROM Events
WHERE CornPalace='1' AND
APPROVED='1' AND
(Image3FileName IS NOT NULL or Image3FileName <> '')
ORDER BY RAND() Limit 5
FROM Events
WHERE CornPalace='1' AND
APPROVED='1' AND
(Image3FileName IS NOT NULL or Image3FileName <> '')
ORDER BY RAND() Limit 5
I meant to say "AND":
SELECT *
FROM Events
WHERE CornPalace='1' AND
APPROVED='1' AND
Image3FileName IS NOT NULL AND
Image3FileName <> ''
ORDER BY RAND() Limit 5
SELECT *
FROM Events
WHERE CornPalace='1' AND
APPROVED='1' AND
Image3FileName IS NOT NULL AND
Image3FileName <> ''
ORDER BY RAND() Limit 5
ASKER
When I try
SELECT * FROM Events WHERE CornPalace='1' AND APPROVED='1' AND Image3FileName IS NOT NULL ORDER BY RAND() Limit 5
I still get records where Image3FileName is blank. I even ran it in the PHPMyAdmin and got the same results
Changing it to SELECT * FROM Events WHERE CornPalace='1' AND APPROVED='1' AND Image3FileName <> ORDER BY RAND() Limit 5 gives me a blank page and an SQL error in PHPMyAdmin
Error is
SQL query:
SELECT *
FROM EVENTS WHERE CornPalace = '1'
AND APPROVED = '1'
AND Image3FileName <>
ORDER BY RAND( )
LIMIT 5
MySQL said:
#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 'ORDER BY RAND() Limit 5' at line 1
SELECT * FROM Events WHERE CornPalace='1' AND APPROVED='1' AND Image3FileName IS NOT NULL ORDER BY RAND() Limit 5
I still get records where Image3FileName is blank. I even ran it in the PHPMyAdmin and got the same results
Changing it to SELECT * FROM Events WHERE CornPalace='1' AND APPROVED='1' AND Image3FileName <> ORDER BY RAND() Limit 5 gives me a blank page and an SQL error in PHPMyAdmin
Error is
SQL query:
SELECT *
FROM EVENTS WHERE CornPalace = '1'
AND APPROVED = '1'
AND Image3FileName <>
ORDER BY RAND( )
LIMIT 5
MySQL said:
#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 'ORDER BY RAND() Limit 5' at line 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
Open in new window