MySQL: Count occurrences of words in a column
- Joel Lipman
- MySQL
- Hits: 4938
This is an article to document how to output the most frequently used words in a MySQL database column.
How?
Note this only applies to MySQL.
Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another:
$mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'"); $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'+1000000 WHERE 'user' = 'Fred'");
What if one of the queries fails? To mitigate the chances of misplacing our millions due to some possible error we must ensure that both queries are executed with the expected result before committing any changes to the data. This where transactions are useful. We can run the queries, then check if some conditions are met before committing the changes in the data:
UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`));Source: Stack Overflow - How to Remove Tabs
UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName` COLLATE utf8_general_ci LIKE b.`CountryName` COLLATE utf8_general_ci SET a.`ccTLD` = b.`ccTLD`
ThisDate ThisDay StartTime TimeOut TimeIn EndTime TotalTimeToday TotalTimeWeek ----------- ----------- ---------- -------- ------- -------- -------------- ------------- 2013-12-02 Monday 09:00 12:00 13:00 17:00 7:00 7:00 2013-12-03 Tuesday 08:45 12:00 13:30 17:45 7:30 14:30 2013-12-04 Wednesday 09:00 12:30 13:30 17:00 7:00 21:30 2013-12-05 Thursday 10:00 12:15 12:45 17:15 7:45 29:15 2013-12-06 Friday 07:00 12:00 13:00 16:30 8:30 37:45 2013-12-07 Saturday - - - - 0:00 37:45 2013-12-08 Sunday 03:00 04:00 - - 4:00 41:45
What? This is an article on how to do a restore from backup on a database but when you get the error: "... database is...
What? This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a...
This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which...
Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all...
Just a quick note as to something that worked for me. Taken from the Oracle forums @...
What? A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and...
Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an...
parameter files joomla source license following display server create data value date time first page windows website creator uploaded report order script case form need field using error user name deluge version where google note list database system code zoho added used file mysql table client work function would find JoelLipman.Com