how do I query with contains string in AWS Log insights
fields @timestamp, @message
filter @message = "user not found"
| sort @timestamp desc
| limit 20
fields @timestamp, @message
filter @message strcontains("User not found")
| sort @timestamp desc
| limit 20
This should work fine
fields @timestamp, @message
| filter @message like /user not found/
| sort @timestamp desc
| limit 20