MySQL LOWER() converts all the characters in a string to lowercase characters.
[code lang=”php”]UPDATE `articles` SET `slug` = LOWER(`slug`)[/code]
Category: MySQL
MySQL replace all whitespaces with dash
[code lang=”php”]UPDATE `articles` SET `slug` = REPLACE( `slug`, ‘ ‘, ‘-‘ )[/code]
Remove everything and including first slash: MySql
[code lang=”php”]UPDATE `song_copy` SET `song_path_new` = substring(`song_path_new`, instr(`song_path_new`, ‘/’) + 1)[/code] From: AAA/BBB/CCC TO: BBB/CCC
Remove everyting after first / slash in mysql
[code lang=”php”]UPDATE my_table SET my_col = SUBSTRING_INDEX(my_col, ‘/’, 1)[/code] From: AAA/BBB/CCC To: AAA
Remove everyting before last / slash in mysql
[code lang=”php”]UPDATE `table` SET `column` = SUBSTRING_INDEX(`column`,’/’,-1);[/code] From: AAA/BBB/CCC To: CCC
MySQL combine two columns and add into new column
MySQL combine two columns and add into new column [code language=”sql”] UPDATE tablename SET combined = CONCAT(zipcode, ‘ – ‘, city, ‘, ‘, state) [/code] Output: zipcode – city, state MySQL combine two columns and add into new column where year is a number [code language=”sql”] UPDATE `tablename` SET cat_path = CONCAT(year, ‘/’, name) WHERE…
Copy one column from one table to another table column – MySql.
Copy one column from one table to another table column – MySql. [code language=”sql”] UPDATE `table` , `table_2` SET table_2.HQ_ID = table.HQ_ID WHERE table_2.name = table.name [/code]
MySQL: Duplicate id into other column in the same table in MySQL
Duplicate id into other column in MySQL. [code language=”sql”] UPDATE contest_cat SET pid = id [/code]
MySQL: Fixing MySQL crashed tables in SSH command line
[code language=”sql”] mysqlcheck –auto-repair –check -u username -p dbpassword [/code]
MySQL: Get the next Auto increment id of a table
[code language=”php”] $result = mysql_query("SHOW TABLE STATUS LIKE ‘".$table_name."’ "); $row = mysql_fetch_array($result); $next_id = $row[‘Auto_increment’]; [/code]