MySQL Syntax Error trying to find empty column value

Question

I'm trying to pass check to see if a field is NULL or empty:

 $query = $this->pdo->prepare('SELECT * FROM `' . $this->table . '` WHERE `wp_permalink` IS NOT NULL AND `wp_permalink` <> "" AND `id` != 2 AND `ga_page_views` != ' . $nogo . ' ORDER BY ga_page_views DESC LIMIT 6');

How can I fix the syntax error for wp_permalink <> ""? Thank you for your help. I am still learning.

Do you want to check if it's not null and not empty or if it's null or empty? From query it looks like it's one and from description the other one. — Daniel Dudas, Apr 03 '19 at 06:17

score 2 · Accepted Answer · answered Apr 03 '19 at 06:44

change the code like this.

$query = $this->pdo->prepare('SELECT * FROM `' . $this->table . '` WHERE `wp_permalink` IS NOT NULL AND `wp_permalink` <> \'\' AND `id` != 2 AND `ga_page_views` != ' . $nogo . ' ORDER BY ga_page_views DESC LIMIT 6');

Single quotes are used to indicate the beginning and end of a string in SQL. Double quotes generally aren’t used in SQL, but that can vary from database to database.

check this link also difference between single and double quotes in SQL

How to use single quote inside an echo which is using single quote

score 0 · Answer 2 · answered Apr 03 '19 at 06:19

0

String literals are denoted by single quotes:

wp_permalink IS NOT NULL and wp_permalink <> ''
-- Single quotes-----------------------------^^

answered Apr 03 '19 at 06:19

Mureinik

297,002
52
306
350

I get a syntax error when I use single quotes, which is why I resorted to double quotes – devManMan Apr 03 '19 at 06:40

MySQL Syntax Error trying to find empty column value

2 Answers2