...

View Full Version : 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
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum