MySQL: Count occurrences of words in a column
- Joel Lipman
- MySQL
- Hits: 6669
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? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to...
What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on...
Why? Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that...
Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like...
Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown...
What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week...
What? Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to...
case parameter used page field script server time website list work display following user joomla code zoho files find record where license value order data name client using function first mysql need table form deluge source date would file report create version uploaded added system windows creator error database note JoelLipman.Com