Re: [Krang-devel] Feature request: add wildcard content search

[Jon D. <jd...@pm...>]

.. add DISTINCT to that query (select distinct story_id ...), and don't
forget to escape the string delimiter to kill off sql injections, but
looking up a few of those story_id's, they do have the text I searched
for.

=20

=20

Jon

=20

=20

From: kra...@li...
[mailto:kra...@li...] On Behalf Of Jon
Davis
Sent: Wednesday, November 28, 2007 10:13 AM
To: kra...@li...
Subject: [Krang-devel] Feature request: add wildcard content search

=20

I just fired up mySql Query Browser and tried this out and got a number
of hits. Is it valid?

=20

select story_id from element

inner join story on element.root_id =3D story.element_id

where lower(data) like '%search text%'

=20

If so, I'd like to request a feature. Please add a raw text content
search feature to the Find Stories -> Advanced view. This is a
much-needed feature that both editors and web devs (like me) need access
to so that we don't have to go poking around at mySql to find stories
that are in need of important fixes / edits, namely in our case our need
to track down all of the stories that have invalid e-mail address domain
names listed.

=20

Thanks,

Jon

=20