In this tutorial, you have learned how to use the SQLite REPLACE() function to replace all occurrences of a substring in a string with a new string. Phone = REPLACE(phone, '410', '+1-410') Code language: SQL (Structured Query Language) ( sql )įinally, query data from the contacts table to verify if the phone has been updated: SELECTĪs shown clearly in the output, the phone numbers have been updated successfully. 5 Answers Sorted by: 8 My soluion: sqlite> CREATE TABLE command (cmd TEXT) sqlite> INSERT INTO command (cmd) VALUES ('ls'), ('cd '), (' mpv movie. Here are the contents of the contacts table:Īfter that, update the phone area code from local (410) to international one(+1-410): UPDATE Then, query data from the contacts table: SELECTĬontacts Code language: SQL (Structured Query Language) ( sql ) VALUES( 'Lily', 'Bush', '41') Code language: SQL (Structured Query Language) ( sql ) INSERT INTO contacts(first_name, last_name, phone) Next, insert into the contacts table some rows: INSERT INTO contacts(first_name, last_name, phone) If the start location is a negative integer then the substring will begin x number of characters from the right. We will use the REPLACE() function to replace strings in a table.įirst, create a new table named contacts that consists of four columns: contact_id, first_name, last_name, and phone: CREATE TABLE contacts ( If the start location is a positive integer then the substring will begin x number of characters from the left of the string. The output is: SQLite REPLACE() string in a table example The following statement uses the REPLACE() function to replace the string 'This' in the string 'This is a cat' with the new string 'That': SELECT REPLACE( 'This is a cat', 'This', 'That') The following example replaces the string 'A' in the string 'AA B CC AAA' with the new string 'Z': SELECT REPLACE( 'AA B CC AAA', 'A', 'Z') Let’s take some examples of using the REPLACE() function. The REPLACE() function is useful for updating character data in a table e.g., update the dead links and typos.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |