Tag archives for search

  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: Word Search

    Problem Statement Given a 2D board and a word, find if the word exists in the grid. The word can be constructed from letters of sequentially adjacent cell, where “adjacent” cells are those horizontally or vertically neighboring. The same letter cell may not be used more than once. For example, Given board =

    word Continue reading...