does "&" and "and" mean thesame thing in MySql?

vickoy23 · 02-23-2009, 04:03 AM

I am asking this because my code is supposed to query mysql database and return rows with the word "and" and not "&" but it does return rows that has either of them present. So, I am wondering if mysql do interchange the word "and" for "&".

`Jeremy · 02-23-2009, 04:06 AM

Post your query.

oesxyl · 02-23-2009, 04:09 AM

Quote:

Originally Posted by vickoy23

I am asking this because my code is supposed to query mysql database and return rows with the word "and" and not "&" but it does return rows that has either of them present. So, I am wondering if mysql do interchange the word "and" for "&".

and and && means same thing. & is bitwise operator not a logical and.

best regards

guelphdad · 02-24-2009, 12:34 AM

also note that && is not standard sql and not portable as a result. Stick to using AND.