Posted by Captain Paralytic on 12/12/06 09:53

But surely that would give him a list of values in columna that begin
with file_path.

I think the OP needs to refer to
http://dev.mysql.com/doc/refman/5.0/en/columns-table.html


Sean wrote:
> Should be what you're looking for:
>
> SELECT * FROM tablea WHERE columna LIKE 'file_path%'
>
> With "LIKE"
>
> 'x%' - starts with x
> '%x' - ends with x
> '%x%' - contains x
>
> Sean
>
> <laredotornado@zipmail.com> wrote in message
> news:1165703841.453964.52110@j44g2000cwa.googlegroups.com...
> > Hi,
> >
> > Using PHP 4.4.4 and MySQL 5 (with an INNODB table), given Table A, how
> > can I programatically find all the columns in A that begin with the
> > string "file_path"?
> >
> > Thanks, - Dave
> >

[Back to original message]