Go Back   CodingForums.com > :: Server side development > PHP
Reload this Page Working with SQL LIKE conditions

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 04-01-2004, 08:21 AM   PM User | #1
browser
New to the CF scene

 
Join Date: Apr 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
browser is an unknown quantity at this point
Working with SQL LIKE conditions
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...
browser is offline   Reply With Quote
Old 04-01-2004, 08:27 AM   PM User | #2
raf
Master Coder


 
Join Date: Jul 2002
Posts: 6,589
Thanks: 0
Thanked 0 Times in 0 Posts
raf will become famous soon enoughraf will become famous soon enough
Welcome here!

$sql ="SELECT * FROM table WHERE field Like 'B%'";
$result = mysql_query($sql) or die ('Queryproblem');
__________________
Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html
raf is offline   Reply With Quote
Old 04-01-2004, 08:37 AM   PM User | #3
browser
New to the CF scene

 
Join Date: Apr 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
browser is an unknown quantity at this point
Thanx a million...
browser is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


« Previous Thread | Next Thread »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:52 PM.
Advertisement
Log in to turn off these ads.