Requête regexp erreur

Bonjour,
Et bonne journée à tous !

Petit soucis avec mon code il me fait une erreur à l'exécution.

Voici le code:

SELECT trunks.trunk_name, destinations.destination_name, (customers_prices.connection + (customers_prices.price * ".$dataline['billsec'].")) as calculHT ".
                        " FROM trunks ".
                        " JOIN customers_prices ON trunks.customer_id = customers_prices.customer_id".
                        " JOIN destinations ON customers_prices.destination_id = destinations.destination_id".
//                      " JOIN prefixes ON customers_prices.destination_id = prefixes.destination_id AND '".$dataline['dst']."' LIKE concat(prefixes.prefix,'%')".
                        " JOIN prefixes ON customers_prices.destination_id = prefixes.destination_id AND '".$dataline['dst']."' LIKE regexp concat'('^',prefix)'".
                        " WHERE '".$dataline['channel']."' LIKE concat('%', trunks.trunk_name, '%')";

Et voici l'erreur:

Erreur SQL !<br> SELECT trunks.trunk_name, destinations.destination_name, (customers_prices.connection + (customers_prices.price * 30)) as calculHT FROM trunks JOIN customers_prices ON trunks.customer_id = customers_prices.customer_id JOIN destinations ON customers_prices.destination_id = destinations.destination_id JOIN prefixes ON customers_prices.destination_id = prefixes.destination_id AND '003322xxxxxx' LIKE regexp concat'('^',prefix)' WHERE 'SIP/xx.xxx.xxx.xx-0003a229' LIKE concat('%', trunks.trunk_name, '%')<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'regexp concat'('^',prefix)' WHERE 'SIP/xx.xxx.xxx.xx-0003a229' LIKE concat('%', ' at line 1solene@dev:~/test$ nano -c fact.php



Si jamais vous voyez ce que j'ai mal fait :D et du coup ce qu'il faudrait que je fasse.


Merci à tous !




Choisis un travail que tu aimes, et tu n'auras pas à travailler un seul jour de ta vie