View Single Post
  #2  
Old 08-08-2006, 08:36 AM
Hary Hary is offline
OSP Starters
 
Join Date: Aug 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Hary is on a distinguished road
Default

You can turn a series of logical expressions into a bitfield:

SELECT A, CONV(CONCAT(b=1, c=2, d=4, e=5, f=6), 2, 2)
FROM table WHERE B=1 AND C=2 OR D=4 OR E=5 OR F=6 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - logical operators issue?
View Single Post
  #2  
Old 08-08-2006, 08:36 AM
Hary Hary is offline
OSP Starters
 
Join Date: Aug 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Hary is on a distinguished road
Default

You can turn a series of logical expressions into a bitfield:

SELECT A, CONV(CONCAT(b=1, c=2, d=4, e=5, f=6), 2, 2)
FROM table WHERE B=1 AND C=2 OR D=4 OR E=5 OR F=6 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote