Advertisement: Over 100,000 Jobs Worldwide. Click here to find one for you.

MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors


http://www.careermidway.com
 
Home / Tricky Select Queries / Question No: 129

How to count the number of rows containing APOSTROPHE in MySQL?

I need to count the number of rows containing "'" APOSTROPHE in a particular field of my table. I made try to do so like below: 

SELECT COUNT(*) FROM my_table WHERE field_name LIKE "%'%"
But I get 0 row in result. Whereas I am sure that "'" exists in many rows.   So pls explain, how to count the number of rows containing apostrophe in MySQL?

Answer No: 129

You are doing right but one thing is missing.  You can correct your query only to escape the apostrophe.  I will rewrite your query like below:

SELECT COUNT(*) FROM my_table WHERE field_name LIKE "%\'%"

Related MySQL FAQs to the Above FAQ

How-to-do-numeric-sorting-within-a-string-field-in-MySQL How to do numeric sorting within a string field in MySQL?

How-to-take-data-back-up-of-single-table How to take data back up of single table?

How-to-find-duplicate-records-from-a-table-in-MySQL How to find duplicate records from a table in MySQL?

How-to-get-last-top-records-in-asceding-order How to get last top records in asceding order?

How-to-move-table-from-one-to-another-MySQL-database How to move table from one to another MySQL database?

How-to-get-parent-table-child-table-and-grandchild-table-aggregates-in-MySQL How to get parent table child table and grandchild table aggregates in MySQL?

How-to-skip-repeating-values-from-the-query-results How to skip repeating values from the query results?

How-to-retrieve--one-child-row-against-each-parent-id How to retrieve one child row against each parent id?

An-important-trick-to-speed-up-select-query An important trick to speed up select query.

How-to-find-the-books-which-have-authors-with-more-than-one-book-in-the-table How to find the books which have authors with more than one book in the table?

How-to-compare-data-of-two-tables-of-two-different-databases-in-MySQL How to compare data of two tables of two different databases in MySQL?

How-to-retreive-multiple-records-without-a-reference-table How to retreive multiple records without a reference table?
About SiteAbout FAQsAffiliates and Sponsors
© 2007 - 2010  www.mysqlfaqs.net
All rights reserved. The site is owned and operated by Mr. Javed Bhatti - Pakistan.