...

View Full Version : Working with SQL LIKE conditions



browser
04-01-2004, 08:21 AM
Normally, in VB and MSAccess this code will work:

< SELECT * FROM table WHERE field Like 'B*';>

and the records starting with B are displayed...

how can i obtain this using PHP... thanks for any help...

raf
04-01-2004, 08:27 AM
Welcome here!

$sql ="SELECT * FROM table WHERE field Like 'B%'";
$result = mysql_query($sql) or die ('Queryproblem');

browser
04-01-2004, 08:37 AM
Thanx a million... :)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum