MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table appsearch(username int, `date` varchar(30), data varchar(30))
insert into appsearch values
(1, '2019-09-16 00:27:12  0000', 'IOS entry'),
(1, 'Fri Apr 12 10:16:01 EDT 2019', 'Android Entry'),
(1, 'Sat Oct 5 10:16:01 EDT 2019', 'Android Entry')
SELECT *
FROM appsearch
WHERE username = 1 AND
      (DATE(date) >= CURRENT_DATE - INTERVAL 200 DAY OR
       STR_TO_DATE(CONCAT(LEFT(date, 10), RIGHT(date, 4)), '%a %b %e %Y') >= CURRENT_DATE - INTERVAL 200 DAY
       )
ORDER BY COALESCE(DATE(date), STR_TO_DATE(CONCAT(LEFT(date, 10), RIGHT(date, 4)), '%a %b %e %Y')) DESC


username
date
data


1
Sat Oct 5 10:16:01 EDT 2019
Android Entry

1
2019-09-16 00:27:12  0000
IOS entry

1
Fri Apr 12 10:16:01 EDT 2019
Android Entry

username	date	data
1	Sat Oct 5 10:16:01 EDT 2019	Android Entry
1	2019-09-16 00:27:12 0000	IOS entry
1	Fri Apr 12 10:16:01 EDT 2019	Android Entry