Erreur SQL !
FROM artistes WHERE (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]\'[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]\'[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]\'[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]\'[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]OR[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]OR[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]OR[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]OR[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]EXISTS(SELECT[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]EXISTS(SELECT[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]EXISTS(SELECT[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]EXISTS(SELECT[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]1[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]1[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]1[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]1[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]FROM[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]FROM[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]FROM[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]FROM[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]pg_tables[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]pg_tables[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]pg_tables[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]pg_tables[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]WHERE[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]WHERE[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]WHERE[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]WHERE[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]tablename=\'users\')--[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]tablename=\'users\')--[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]tablename=\'users\')--[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]tablename=\'users\')--[[:>:]]") AND affiche_artiste="1" ORDER BY nom_artiste ASC
Got error 'parentheses not balanced' from regexp
FROM artistes WHERE (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]\'[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]\'[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]\'[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]\'[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]OR[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]OR[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]OR[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]OR[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]EXISTS(SELECT[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]EXISTS(SELECT[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]EXISTS(SELECT[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]EXISTS(SELECT[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]1[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]1[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]1[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]1[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]FROM[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]FROM[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]FROM[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]FROM[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]pg_tables[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]pg_tables[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]pg_tables[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]pg_tables[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]WHERE[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]WHERE[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]WHERE[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]WHERE[[:>:]]") AND affiche_artiste="1" AND (REPLACE (nom_artiste,"é","e") REGEXP "[[:<:]]tablename=\'users\')--[[:>:]]" OR REPLACE (prenom_artiste,"é","e") REGEXP "[[:<:]]tablename=\'users\')--[[:>:]]" OR REPLACE (nom_complet_artiste,"é","e") REGEXP "[[:<:]]tablename=\'users\')--[[:>:]]" OR biographie_artiste REGEXP "[[:<:]]tablename=\'users\')--[[:>:]]") AND affiche_artiste="1" ORDER BY nom_artiste ASC
Got error 'parentheses not balanced' from regexp