Finding specific column names

Finding specific column names

am 09.12.2006 23:37:21 von laredotornado

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

Re: Finding specific column names

am 12.12.2006 09:53:27 von Sean

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

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
>

Re: Finding specific column names

am 12.12.2006 10:53:02 von Captain Paralytic

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
>
> 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
> >

Re: Finding specific column names

am 12.12.2006 15:43:52 von Sean

Indeed you're right ... I misread.



"Captain Paralytic" wrote in message
news:1165917181.933414.119590@73g2000cwn.googlegroups.com...
> 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
>>
>> 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
>> >
>