Instr

[elisa44]

Me queda claro que si funciona en oracle no quiere decir que funcione en MySql, solo quiero transformar, por decirlo de una forma. esa consulta MySql, por eso mi consulta. Así están creadas las tablas:
CREATE TABLE tbl_systemclass (
sys_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
filename VARCHAR(30) NOT NULL,
url VARCHAR(20) NULL,
itemname VARCHAR(20) NULL,
sec_id INTEGER UNSIGNED NULL,
menuitem VARCHAR(5) NULL DEFAULT true,
PRIMARY KEY(sys_id),
INDEX tbl_systemclass_FKIndex1(sec_id),
FOREIGN KEY(sec_id)
REFERENCES tbl_section(sec_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
)

CREATE TABLE tbl_accessright (
acr_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
rol_id INTEGER UNSIGNED NOT NULL,
sys_id INTEGER UNSIGNED NOT NULL,
PRIMARY KEY(acr_id, rol_id, sys_id),
INDEX idx_rol_id(rol_id),
INDEX idx_sys_id(sys_id),
FOREIGN KEY(rol_id)
REFERENCES tbl_role(rol_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
FOREIGN KEY(sys_id)
REFERENCES tbl_systemclass(sys_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION
)

y la consulta es esta:
SELECT sys.sys_id FROM tbl_systemclass sys, tbl_accessright acr WHERE sys.sys_id=acr.sys_id AND acr.rol_id=? AND (instr (?, sys.url) =1)

Gracias