Brandon Price writes: > SELECT gw.ip_addr, gw.port, gw.uri_scheme, gw.transport, gw.strip, > gw.prefix FROM gw, lcr WHERE ''<sip:[EMAIL PROTECTED]>'' > LIKE lcr.from_uri AND '15184782222' LIKE CONCAT(lcr.prefix, '%') AND > lcr.grp_id = gw.grp_id ORDER BY CHAR_LENGTH(lcr.prefix), lcr.priority > DESC, RAND()
lcr module only adds a single single quote before and after from uri: q_len = snprintf(query, MAX_QUERY_SIZE, "SELECT %.*s.%.*s, %.*s.%.*s, %.*s.%.*s, %.*s.%.*s, %.*s.%.*s, %.*s.%.*s FROM %.*s, %.*s WHERE '%.*s' LIKE %.*s.%.*s AND '%.*s' LIKE CONCAT(%.*s.%.*s, '%%') AND %.*s.%.*s = %.*s.%.*s ORDER BY CHAR_LENGTH(%.*s.%.*s), %.*s.%.*s DESC, RAND()", -- juha _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
