How to make/compose a query against a SQLite database?

Question

SQLite

need to find filmix.net
and replace with https://filmix.me
if doing UPDATE `moz_places` SET `url`= REPLACE(`url`, 'filmix.net', 'filmix.me');
then the command works fine,
but if I do UPDATE `moz_places` SET `url`= REPLACE(`url`, ' http:// filmix.net', ' https:// filmix.me');
I get an error
SQLiteManager: Likely SQL syntax error: UPDATE `moz_places` SET `url`= REPLACE(`url`, ' http://filmix.me, ' https://filmix.me '); [ near "https": syntax error ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]
I understand that you need to somehow escape the characters "//" or ":"

Answer 1

You didn't close the quote :)