Hi, I just bough my "Introduction to SQL 4th edition" as per a list member's advice.
Before I had a chance to take it home and start going through it I came across an SQL statement that I could use some help understanding. The statement is: SELECT COUNT(*) FROM products WHERE productid=808800033 AND (allowcountry2 & 0x0000000000000001) SELECT COUNT(*) FROM products WHERE productid=808800033 AND (allowcountry1 & 0x8000000000000000) I believe the allowcountry part is a bit pattern lookup but I can't find a definition for the & and so I am not sure what the statement does bar count the results. Can someone enlighten me? I should point out that this command is used on a MySQL DB. Thanx, Dp. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
