title: Mysql bad date (data) in string field how to find/validate?
body: <p>I have a string field in Mysql (date fields imported from from MSSQL) and I'm using the following to convert the string value and place it in a new (MYSQL) date-time field,</p>
  
  <p>Update Table_name set 
      STATUS_DATE= STR_TO_DATE(substring_index(SSTATUS_DATE," ",1),'%c/%e/%Y'),</p>
  
  <p>somewhere in the table I have bad data and the query stops and reverses out the results  SO I don't know how to find the bad data record to "fix" it Ideas? I'd like to just do a simple query to determine which record does not convert?
  The error message says That CABANA is not a date, duh, I suspect that the substr index is messed up so I get data from the prior or following field, but I don;t know, and I don't know how to query for bad data? ie that which won't pass the conversion?</p>