You need to escape the apostrophe first so
select count(*) from table where field like '%\'%' On Tue, Mar 25, 2008 at 2:37 PM, Saravanan <[EMAIL PROTECTED]> wrote: > hi lists, > > I want to count the number of rows containing "'" aphostrophe in a > particular field. I tried with > > select count(*) from table where field like "%'%" > > i get only 0 counts. but I am sure that exists in many rows. > > how to query them > > Saravanan > > > > > ____________________________________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- Help build our city at http://free-dc.myminicity.com !
