You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is it just me or does the following query generate unexpected results:
CREATE TABLE Names (
Name TEXT COLLATE NOCASE
);
INSERT INTO Names VALUES ('Michael');
SELECT * FROM Names WHERE Name = 'michael' -- one row returned
SELECT * FROM Names WHERE Name REGEXP '^michael$' -- zero rows returned
SELECT * FROM Names WHERE Name REGEXP '^Michael$' -- one row returned
The text was updated successfully, but these errors were encountered:
Is it just me or does the following query generate unexpected results:
The text was updated successfully, but these errors were encountered: