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

[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 "&".

[`Jeremy]

Post your query.

[oesxyl]

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]

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