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

13 June 2016 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: *

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

26 October 2012 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: *

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

24 July 2013 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: *

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

09 September 2013 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

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

13 June 2016 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: *