AND / && in MySQL query: any difference?

[marcnyc]

Is there any difference between using AND or using && in a SQL query? Thanks

[laserlight]

You should read:
http://www.mysql.com/doc/en/Logical_Operators.html

[marcnyc]

I just read that article but I am still not exactly sure how to interpret it...

Using values of the project I am working on, and in human language, how would you read these two expressions differntly?

WHERE reviews2_category.id = reviews2_reviews.id_category && category NOT LIKE 'book%' AND category NOT LIKE 'magazine%'

as opposed to:

WHERE reviews2_category.id = reviews2_reviews.id_category && category NOT LIKE 'book%' && category NOT LIKE 'magazine%'

What is the difference between these two?

[Weedpacket]

There isn't any difference. AND is traditional.

[marcnyc]

Thanks weedpacket, I thought there was no difference but you never know and I wanted to make sure. Thanks a lot for clarifying that to me!