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]
