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