![]() If you want to search and replace a substring in a table column, you use the following syntax: UPDATEĬolumn_name = REPLACE( column,old_text,new_text)Ĭondition Code language: SQL (Structured Query Language) ( sql ) ) Code language: SQL (Structured Query Language) ( sql ) The following example replaces the substring tt with xx in a URL: SELECT REPLACE ( In this example, we replaced all characters ‘A’ with the character ‘Z’ in a string. See the following example of using the REPLACE()function: SELECT REPLACE ( 'ABC AA', 'A', 'Z') Code language: SQL (Structured Query Language) ( sql )
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |