Bonjour,

normalement, en utilisant l'opérateur LIKE dans une clause WHERE, je pensais résoudre mon problème, mais select * FROM ticket2.t_us_user where user_sesaid LIKE 179% donne l'erreur
Error Code: 1064. 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 '% #627939' at line 1
Le DDL de la table est :
Code sql : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
CREATE TABLE `t_us_user` (
  `user_ident` int unsigned NOT NULL AUTO_INCREMENT,
  `user_sesaid` int,
  `user_firstname` varchar(100) NOT NULL,
  `user_lastname` varchar(100) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `lic_ident` int unsigned NOT NULL,
  `cou_ident` int unsigned NOT NULL,
  `bu_ident` int unsigned NOT NULL,
  `loc_ident` int unsigned NOT NULL,
  `user_ident_manager` int unsigned DEFAULT NULL,
  `OZ_ident` int unsigned DEFAULT NULL,
  PRIMARY KEY (`user_ident`),
  UNIQUE KEY `idx_us_user_email` (`user_email`),
  KEY `idx_us_lic_ident` (`lic_ident`),
  KEY `idx_us_cou_ident` (`cou_ident`),
  KEY `idx_us_bu_ident` (`bu_ident`),
  KEY `idx_us_loc_ident` (`loc_ident`),
  KEY `idx_us_user_ident_manager` (`user_ident_manager`),
  KEY `idx_us_OZ_ident` (`OZ_ident`),
  CONSTRAINT `fk_us_user_ibfk_1` FOREIGN KEY (`lic_ident`) REFERENCES `t_li_license` (`lic_ident`),
  CONSTRAINT `fk_us_user_ibfk_2` FOREIGN KEY (`cou_ident`) REFERENCES `t_cou_country` (`cou_ident`),
  CONSTRAINT `fk_us_user_ibfk_3` FOREIGN KEY (`bu_ident`) REFERENCES `t_bu_businessunit` (`bu_ident`),
  CONSTRAINT `fk_us_user_ibfk_4` FOREIGN KEY (`loc_ident`) REFERENCES `t_lo_location` (`loc_ident`),
  CONSTRAINT `fk_us_user_ibfk_5` FOREIGN KEY (`user_ident_manager`) REFERENCES `t_us_user` (`user_ident`),
  CONSTRAINT `fk_us_user_ibfk_6` FOREIGN KEY (`OZ_ident`) REFERENCES `t_oz_organization` (`OZ_ident`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
Merci de me dire où est l'erreur...