Sqlite, exclusive or. How do I clear the flag?

Set the flag I write SET status=status|? How do I clear the flag? Usually I write SET status=status&( – 1 ^?) but ^ is illegal in sqlite. How can I clear the flag or use an exclusive OR?
sqlite does not seem to have an xor operator. You can simulate it using the following method:

select (~(a&b))&(a|b)

For example, when covering 1111(15) with 0100(4):

select (~(15&4))&(15|4)

The answer is 1011(11). So you can clear the flag.

< /p>

Set the flag I write SET status=status|? How do I clear the flag? Usually I write SET status=status&( – 1 ^?) but ^ is illegal in sqlite. How can I clear the flag or use an exclusive OR?

SQLite does not seem to have the xor operator. You can simulate it using the following method:

select (~( a&b))&(a|b)

For example, when covering 1111(15) with 0100(4):

select (~(15&4 ))&(15|4)

The answer is 1011(11). So you can clear the flag.

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 884 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.