Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming mycolumn is required, the following 5 results were found.

  1. Convert foreign characters to English alphabethttps://www.joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

    similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'À', 'A'); UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'Á', 'A'); UPDATE `myTable` t...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  2. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    to case and accent-sensitive). ** ** ** ** Usage: ** ** EXEC [usp_ListDistinctValuesAndCounts] 'myDB.dbo.myTable', 'myColumn1,myColumn2', 'Latin1_General_CS_AS'; ** ** ** ** Return Values : Table of three columns: ** ** - myValue: the distinct values **...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  3. Modifying columns in a tablehttps://www.joellipman.com/articles/else/database/modifying-columns-in-a-table.html

    All SQL -- Add a column to an existing table (giving it datatype char(2) and allowing NULL) ALTER TABLE myTable ADD myColumn CHAR(2) NULL -- Delete a column ALTER TABLE myTable DROP COLUMN myColumn -- Reorder a column ALTER TABLE myTable MODIFY COLUMN...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  4. MySQL: Find all non-alphanumeric rowshttps://www.joellipman.com/articles/else/database/mysql/mysql-find-all-non-alphanumeric-rows.html

    URL friendly characters. How? -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that are non-alphanumeric but ignore underscores SELECT * FROM myTable...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  5. Trim values along with the tabhttps://www.joellipman.com/articles/else/database/mysql/trim-values-along-with-the-tab.html

    commands. Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to Remove Tabs

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 1 - 5 of 5