Posted by Sean on 12/12/06 08:53

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]