What is right syntax of write query with LIke and Any Operator?

Asked Feb 10 '20 at 06:00

Active Feb 10 '20 at 06:00

Viewed 17 times

I am creating a application in node and sequelize, i run the function that generate the query like below

SELECT `id`, `product_title`, `product_size`, `product_author`, `description`, `product_category`, `createdAt`, `updatedAt` FROM `products` AS `products` WHERE `products`.`product_category` LIKE ANY ('%Shirts%', '%Jeans%', '%Pents%')

But it gives me syntax error, what is going wrong in this query, because i never use this query before.

Please help me to find the error.

asked Feb 10 '20 at 06:00

You can't use `LIKE` with `ANY` – Nick Feb 10 '20 at 06:02
1

use `LIKE` with `OR` – Alive to die - Anant Feb 10 '20 at 06:03
@Nick So can you give me any solution for find the data match from array – Feb 10 '20 at 06:04
1

[MySQL LIKE IN()?](https://stackoverflow.com/questions/1127088/mysql-like-in) – Alive to die - Anant Feb 10 '20 at 06:04
@AnantSingh---AlivetoDie definitely a dupe... – Nick Feb 10 '20 at 06:07
@RobinSingh see the question Anant posted in their comment – Nick Feb 10 '20 at 06:07

What is right syntax of write query with LIke and Any Operator?

0 Answers0