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 "&".
oesxyl
02-23-2009, 04:09 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 "&".
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.