Minor point of note: just remove the whole condition to get the same
effect with less overhead. Also try using %% instead of %.
--Noah
On Sep 14, 2006, at 8:29 PM, [EMAIL PROTECTED] wrote:
>
> I'm fairly new to generating my own reports (and to SQL in
> general), so
> I may be missing something obvious, but is the LIKE syntax supported
> for reports? I can't seem to get it to work. We are using postgres as
> the Track DB.
>
> The following query works:
> SELECT id AS ticket, summary, component
> FROM ticket t
> WHERE component IN ('cuemkvid')
>
>
> But this one with a LIKE does not:
> SELECT id AS ticket, summary, component
> FROM ticket t
> WHERE component LIKE '%'
>
> Any help would be greatly appreciated. Thanks!
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/trac-users
-~----------~----~----~----~------~----~------~--~---
