cf1c012cd06342fb0a5db804847dcc90c3cd3b66
markd
  Wed Sep 21 14:09:19 2016 -0700
revert change made to sqlListTablesLike done due to my lame missunderstanding of how it worked

diff --git src/hg/lib/jksql.c src/hg/lib/jksql.c
index 8b39f3c..5949e46 100644
--- src/hg/lib/jksql.c
+++ src/hg/lib/jksql.c
@@ -904,37 +904,38 @@
         "SELECT DISTINCT tableName FROM %s WHERE tableName %s ORDER BY tableName", tableList, likeExpr);
 
 struct sqlResult *sr = sqlGetResult(conn, query);
 char **row;
 while ((row = sqlNextRow(sr)) != NULL)
     {
     el = slNameNew(row[0]);
     slAddHead(&list, el);
     }
 slReverse(&list);
 sqlFreeResult(&sr);
 return list;
 }
 
 static struct slName *sqlListTablesForConn(struct sqlConnection *conn, char *likeExpr)
-/* run SHOW TABLES on connection and return a slName list */
+/* run SHOW TABLES on connection and return a slName list.  LIKE expression
+ * can be NULL or string e.g. "LIKE 'snp%'" */
 {
 char query[256];
 if (likeExpr == NULL)
     safef(query, sizeof(query), NOSQLINJ "SHOW TABLES");
 else
-    safef(query, sizeof(query), NOSQLINJ "SHOW TABLES LIKE \"%s\"", likeExpr);
+    safef(query, sizeof(query), NOSQLINJ "SHOW TABLES %s", likeExpr);
 
 struct slName *list = NULL, *el;
 
 struct sqlResult *sr;
 char **row;
 sr = sqlGetResult(conn, query);
 while ((row = sqlNextRow(sr)) != NULL)
     {
     el = slNameNew(row[0]);
     slAddHead(&list, el);
     }
 slReverse(&list);
 sqlFreeResult(&sr);
 return list;
 }