Indexes are defined for the table by: SHOW INDEX FROM <tablename>; Post navigation How can we find out which auto increment was assigned on Last insert? What do you mean by % and _ in the LIKE statement?