Simple Select INNER JOIN statement - SQL query ERROR

Question

I have a simple MySQL statement that keeps showing an error.

type is an column in table ps_product_custom_statistics_weekly and i would like to select only the value from type where it has an value of all.

SELECT `cat`.`brand_name`
FROM `ps_product_brand` AS `cat`
INNER JOIN `ps_product_custom_statistics_weekly` AS `cat_p` 
ON `cat_p`.`id_product` = `cat`.`id_product`
WHERE `cat_p`.`type` LIKE `%all%`
AND `cat_p`.`rank` <= 16;

Error msg :

#1054 - Unknown column '%all%' in 'where clause'

(i dont understand why it tells me this, im using cat_p.type to select column and LIKE %all% to get string from that column, please help)

Table:

ps_product_custom_statistics_weekly

  product_id        type            rank
+-------------+--------------+------------------+
|      1      |    weekly    |       20         |
+-------------+--------------+------------------+
|      2      |      all     |       10         |
+-------------+--------------+------------------+

Thanks

Use the correct quote characters, backtick (`) for identifiers, single quotes (') for string literals. — HoneyBadger
– HoneyBadger, Commented Jan 16, 2018 at 9:41
please tag correctly, it should be only MySQL, not sql server also — Md. Suman Kabir
– Md. Suman Kabir, Commented Jan 16, 2018 at 9:41

diiN__________ · Accepted Answer · 2018-01-16 09:41:46Z

1

The problem is that you are using backticks instead of single quotes. Use it like this:

WHERE `cat_p`.`type` LIKE '%all%'

answered Jan 16, 2018 at 9:41

diiN__________

7,7197 gold badges49 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

KMS · Accepted Answer · 2018-01-16 09:42:44Z

1

You should give quotes to like condition like below,

SELECT `cat`.`brand_name`
FROM `ps_product_brand` AS `cat`
INNER JOIN `ps_product_custom_statistics_weekly` AS `cat_p` 
ON `cat_p`.`id_product` = `cat`.`id_product`
WHERE `cat_p`.`type` LIKE '%all%'//Change quotes
AND `cat_p`.`rank` <= 16;

Backquotes ` should not work for string manipulation in mysql query

answered Jan 16, 2018 at 9:42

KMS

5844 silver badges16 bronze badges

Comments

Sachin Tyagi · Accepted Answer · 2018-01-16 09:45:04Z

0

Solution must be

SELECT `cat`.`brand_name`
FROM `ps_product_brand` AS `cat`
INNER JOIN `ps_product_custom_statistics_weekly` AS `cat_p` 
ON `cat_p`.`id_product` = `cat`.`id_product`
WHERE `cat_p`.`type` LIKE '%all%'
AND `cat_p`.`rank` <= 16;

As Like value must be in '' not in ``

answered Jan 16, 2018 at 9:45

Sachin Tyagi

1,29715 silver badges21 bronze badges

Collectives™ on Stack Overflow

Simple Select INNER JOIN statement - SQL query ERROR

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related