How can I use operators(!=, < , > etc) for checking

jobayer_34 · September 7th, 2012, 12:20 AM

Dear Sir,

I tried to use operators(!=, < , > etc) for finding data from database using this query

"SELECT `id`, `name`, `thumbnail`, `category_id` FROM (`products`) WHERE `status` = 'active' AND `id` `!=` '6' ORDER BY `category_id` desc LIMIT 100", but found error message.

Can you please suggest me how can I fix this problem ?

Thanks
Jobayer

plavalle · September 9th, 2012, 07:29 AM

What's the error you get from the DB?

UseLess · September 10th, 2012, 06:13 AM

Greetings,

Quote:

Originally Posted by plavalle

What's the error you get from the DB?

See here: Getting error message while trying to checking field using operators in active field

jobayer_34 · September 10th, 2012, 11:02 AM

It shows "Error Number: 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 '`!=` '6' ORDER BY `category_id` desc LIMIT 100' at line 4

SELECT `id`, `name`, `thumbnail`, `category_id` FROM (`products`) WHERE `status` = 'active' AND `id` `!=` '6' ORDER BY `category_id` desc LIMIT 100".

Thanks in Advance
Jobayer

plavalle · September 10th, 2012, 11:15 AM

Code:

SELECT `id`, `name`, `thumbnail`, `category_id` FROM (`products`) WHERE `status` = 'active' AND `id` != '6' ORDER BY `category_id` desc LIMIT 100

UseLess · September 11th, 2012, 07:13 AM

Greetings,

You're missing the point in the topic I mentioned above the OP says this;

Quote:

Originally Posted by jobayer_34

Dear Sir,

Thanks for your message. I have used db->where('id !=', '6') then it produces this query. Can you please suggest me how can I use operators for checking (I want to check where id!=6)?

Thanks in advance
Jobayer

so he's using the class method 'where' to generate the WHERE clause BUT it's wrapping the != in back ticks/quotes so it's generating an error when the sql is executed.

plavalle · September 11th, 2012, 07:45 AM

Quote:

Originally Posted by UseLess

Greetings,

You're missing the point in the topic I mentioned above the OP says this;

so he's using the class method 'where' to generate the WHERE clause BUT it's wrapping the != in back ticks/quotes so it's generating an error when the sql is executed.

Yep, I missed that other post ...

I responded there. NOT EQUAL operators are either != or <>