Return to Snippet

Revision: 51276
at September 20, 2011 05:10 by nielsenrc


Initial Code
SELECT cms_content.content_id, cms_content.content_alias, cms_content.content_id, cms_content_props.content  FROM cms_content, cms_content_props WHERE cms_content.content_id = cms_content_props.content_id AND cms_content_props.content LIKE '%#%';

Initial URL

                                

Initial Description
Get all page names and ids from the DB of pages with content containing '#'

Initial Title
CMS Made Simple Query for Pages Containing \'#\'

Initial Tags
mysql

Initial Language
MySQL