Does anyone know how to query the database to find entry data based on a slug? The only table field I see that contains slug data is in craft_entryversions.data in json format. Anyone ever tried querying for matches?
If you're talking about querying using SQL directly, then the craft_elements_i18n
table is where all of the slugs are kept.
-
Yeah I ended up bumping into that table and I see elementId is the entry id. Getting image data gets tricky I guess. – MrT Mar 12 '15 at 14:12
craft_elements_i18n
table? – Josh Angell Mar 11 '15 at 14:17