Tag: MySQL

Howto backup mysql stored functions and stored procedures This is how you can backup you MySQL database(s) and stored procedures # mysqldump --routines <dbname> Or you can backup only the stored procedures # mysqldump...
mysql alternative to PHP substr_count function The substr_count function in PHP counts the number of substring occurrences. This post describes how to create a mysql stored function to behave just like PHP’s substr_count...
Howto combine two columns into one in mysql This is how you can combine (or concatenate or merge) data from two table columns into one column using a mysql SQL query. SELECT CONCAT(firstname,lastname) AS 'name' FROM...
MySQL search and replace This is a simple SQL query to perform search and replace in a MySQL table update tablename set fieldname = replace(fieldname,'search_for_this','replace_with_this');