mysql count occurrences of special character in a field

by 
select length('aa:bb:cc:dd')-length(replace('aa:bb:cc:dd',':',''));

source: http://lists.mysql.com/mysql/215049

More Related Contents:

  1. How to update multiple MySQL table entries with different id?
  2. Can’t insert data into mysql database using PHP [closed]
  3. which is better every user have a table or just a row [closed]
  4. I don’t know what’s wrong with my code. I’m a newbie. The prob is – Notice: Undefined variable: result [duplicate]
  5. How to run deprecated php codes on the latest XAMPP [duplicate]
  6. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  7. How can I use PDO to fetch a results array in PHP?
  8. Is closing the mysql connection important?
  9. MySQL check if a table exists without throwing an exception
  10. Shortcomings of mysql_real_escape_string?
  11. Alternative to mysql_real_escape_string without connecting to DB
  12. HTML – Change\Update page contents without refreshing\reloading the page
  13. Calculate age based on date of birth
  14. How to write a stored procedure using phpmyadmin and how to use it through php?
  15. Doing calculations in MySQL vs PHP
  16. Geo-Search (Distance) in PHP/MySQL (Performance)
  17. PHP mysql search multiple tables using a keyword
  18. How do I count unique visitors to my site?
  19. php code to test pdo is available?
  20. PHP / MySQL build tree menu
  21. Long integer is transformed when inserted in shorter column, not truncated. Why? What is the formula?
  22. How to create Codeigniter language files from database?
  23. Laravel $q->where() between dates
  24. WordPress prepared statement with IN() condition
  25. PHP: Inserting Values from the Form into MySQL
  26. Using PHP to execute multiple MYSQL Queries
  27. Select MYSQL rows but rows into columns and column into rows
  28. How to run multiple insert query in SQL using PHP in one go?
  29. PHP MySQL set Connection Timeout
  30. The ultimate emoji encoding scheme

Leave a Comment