- var_dump: documentation ( source)
- preg_match_all: documentation ( source)
<?php
preg_match_all('/.*?(?<columnname>`.+?`|\S+)\s*(?<operator>=|<|>|<>)\s*(?<value>`.+?`|\S+)\s*(AND|OR)/', 'algo = asslgo AND caca=8', $matches);
var_dump($matches);