Query_Sol. for MySQL users

-- In MySQL, the equivalent function to the CHARINDEX is LOCATE

SELECT EventName, EventDate,
    LOCATE('this', EventDetails) AS thisPosition,
    LOCATE('that', EventDetails) AS thatPosition,
    (LOCATE('that', EventDetails) - LOCATE('this', EventDetails)) AS 'Offset'
FROM tblevent
WHERE
    LOCATE('this', EventDetails) > 0
    AND LOCATE('that', EventDetails) > 0
    AND LOCATE('that', EventDetails) > LOCATE('this', EventDetails);