Thread

I am trying to located particular channel entries that have a URL_Title with a specific string.
Some of our URL_Title are of the form Title_2006
So I want to locate all entries that have the _2006 in the URL_Title in a particular channel.  The 2006 is not in the Title or in the body, so a standard CP search does not work.

Is there a way to do this or can I write some kind of SQL query in the Tools>SQL Manager?

Hi artlab,

While you could create a query that would return those entries, you wouldn’t be able to edit them in via the SQL Manager. You might be interested in an add-on called Zenbu that adds several more searching options for editing entries.

Zenbu doesn’t allow this it seems.  Not URL_Title search at least.

If you can tell me the query, just having the resultant list by ID or name would help!  At least it narrows down the search.

You can try running this in the Query Form:

SELECT * FROM exp_channel_titles WHERE url_title LIKE '%_2006%'

That should return a list of results where the url_title contains “_2006”. That result set will include the entry ID and the Title for the entries you are looking for as well.

Hope that helps!