On 28/03/2009 4:37 AM, Dermot wrote: > 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.
Here's some meta-advice: Check for an index at the back of the book. If none, ask for a refund. "&" should be listed either under a "Symbols" (or similar) section before the letter "A", or under "operators". If not, ask for a refund. HTH, John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
