Posted by Sean on 12/12/06 14:43

Indeed you're right ... I misread.



"Captain Paralytic" <paul_lautman@yahoo.com> 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
>>
>> <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]