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