Tag archives for string

  1. Pure SQL Approach to Globally Search and Replace Strings in MySQL Database

    Say, in MySQL, if you would like to find the string 'http://www.guiguan.net' in a database and replace all of its occurrences (from all columns/fields of all tables in the database) with another string 'https://www.guiguan.net', because that you just moved to a more secure world, then you can achieve this purely using native SQL statements in MySQL. First, launch your favourite MySQL Continue reading...

  2. LeetCode in Swift: Reverse Words in a String

    Problem Statement Given an input string, reverse the string word by word. For example: Given s = “ the sky is blue”, return “ blue is sky the”. Clarification: What constitutes a word? A sequence of non-space characters constitutes a word. Could the input string contain leading or trailing spaces? Yes. However, your reversed string should not contain leading or trailing spaces. How Continue reading...