Re: LIKE keyword in SELECT does not work in MySql Cluster

[met dos]

Here what you asked:

| UM_USER | CREATE TABLE `UM_USER` (
`UM_ID` int(11) NOT NULL AUTO_INCREMENT,
`UM_USER_NAME` varchar(255) NOT NULL,
`UM_USER_PASSWORD` varchar(255) NOT NULL,
`UM_SALT_VALUE` varchar(31) DEFAULT NULL,
`UM_REQUIRE_CHANGE` tinyint(1) DEFAULT '0',
`UM_CHANGED_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`UM_TENANT_ID` int(11) NOT NULL DEFAULT '0',
`UM_USER_PASSWORD_MD5` varchar(255) DEFAULT NULL,
`UM_USER_EMAIL` varchar(100) DEFAULT NULL,
`UM_USER_CREATION_DATE` varchar(15) DEFAULT '0',
`UM_USER_MODIFICATION_DATE` varchar(15) DEFAULT '0',
`UM_NAME` varchar(100) DEFAULT NULL,
PRIMARY KEY (`UM_ID`,`UM_TENANT_ID`),
UNIQUE KEY `UM_USER_NAME` (`UM_USER_NAME`,`UM_TENANT_ID`)
) ENGINE=ndbcluster AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COMMENT='FK_dm_device_id' |