You are here: Re: Finding specific column names « PHP SQL « IT news, forums, messages
Re: Finding specific column names

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
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация