Yazan: dp | 02 June 2009 | Comments
Categories: Uncategorized
Recently, I needed to find all of the data in a table that was being used for HTML output, that had non-printable characters. The following SQL statement should do that for you:
select id, name
from table_name
where name not regexp ‘^[a-zA-Z0-9_ ,&;\/<>(²):%*#?$|!+.\"\'-]+$;
This code is MySQL specific, but should be applicable anywhere, really.
Yazan: dp | 26 May 2009 | Comments
Categories: Uncategorized
I’ve been working on getting all of the sites on which I have public profiles compiled together into a list. Currently, the fruits of that effort can be seen in the sidebar of this site. All of those urls should have a rel=”me” attribute on them, so that the social graph is correct, [...]
