Find all tables containing column with specified name Many developers asking is it possible to find a column name in all tables which has columns specified name. So here is query to search a column in a SQL Server database. Search in all tables SELECT c.name AS 'Column', t.name AS 'TableName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name = 'MycolumnName' --specify search column name ORDER BY TableName,Column Search in all tables and views SELECT COLUMN_NAME AS 'Column', TABLE_NAME AS 'TableName' FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'MyColumnName' --specify search column name ORDER BY TableName,Column;

Convert datetime string to unix timestamp from string column in mysql

Rathnakar

I have a column (value) with mediumtext NULL where, among other things, are also datetime string values saved. I have to select all datetime values and convert them to Unix datetime.

the selecting I have to like so

SELECT value FROM thetable WHERE value REGEXP '^["]+(2[0-9]{3})'

but ho do I do the uptate tried this

UPDATE thetable set value = UNIX_TIMESTAMP(value) WHERE value REGEXP '^["]+(2[0-9]{3})';

but it does not affect anything. I think I need a combination of both.