I am going through trying to clean up some of my data... and I know some bad stuff is in there needed to be cleaned. Notquite sure how I can search for in in MySQL.
I want to search for tabs and returns... sort of a "Select * from Links where Description LIKE '%RETURN%'." is this possible? What do I use to return a tab or return character?
Also, is there any way to use the perl "^" and "$" commands in a search- that is, the leftmost character is a XXX or the rightmost character is a XXX? I want to find fields that begin or end with an extra space....
Thanks!
dave
Big Cartoon DataBase
Big Comic Book DataBase
I want to search for tabs and returns... sort of a "Select * from Links where Description LIKE '%RETURN%'." is this possible? What do I use to return a tab or return character?
Also, is there any way to use the perl "^" and "$" commands in a search- that is, the leftmost character is a XXX or the rightmost character is a XXX? I want to find fields that begin or end with an extra space....
Thanks!
dave
Big Cartoon DataBase
Big Comic Book DataBase