This is my regex .+\s*(?=!|<|>|=|LIKE) and it doesnt work.
I want to match everything on the left side to the operators <,>,<=,>=,=,!=,LIKE.
Obviously my regex doesn't do the work so I am wondering if you could help me.
Check out what is wrong on this link: https://regex101.com/r/skRdTr/1 (it matches everything on the left side, including >,<,! if operator is <=,>=,!=)
(\w+\s+)(=|LIKE|<|>|>=|<=|!=){1}(.+?)(?=[!<>=]+|LIKE)