Need Help Using LIKE in MySql statement

[stressedsue]

Hello,

 

I need to extract records from a database that start with a specific string field.  I want to use LIKE in my statement to accomplish this, but could use an example to follow.  I keep reading that I need to use the escape character with LIKE, but am not sure about the proper syntax. 

 

My statement currently looks something like this:  $query_Sched1 = sprintf("SELECT * FROM schedule WHERE sem = %s AND (comment1 LIKE 'starts 03%') ORDER BY dept, number, section, orderby ASC", $colname_Sched);

 

When I execute this, I receive this error message : "You have an error in your SQL syntax near 'LIMIT 0, 25' at line 1"

 

Any help or examples on how to use 'LIKE' properly would be greatly appreciated.

 

Thanks in advance!!!!

[New Coder]

Try

 

$query_Sched1 = "SELECT * FROM schedule WHERE sem = \"%s\" AND comment1 LIKE \"starts 03%\" ORDER BY dept, number, section, ASC";

 

 

Hope this helps

 

Not sure what you are trying to do with this part though:- , $colname_Sched);

 

Cheers

[xec]

hiii ,

    $query_Sched1 = "SELECT * FROM schedule WHERE sem like '%s%' AND comment1 LIKE \"starts 03%\" ORDER BY dept, number, section, ASC";

   

[xec]

Hii,

    try this query , it will definitely work...

 

$query_Sched1 = "SELECT * FROM schedule WHERE sem like '%s%' AND comment1 LIKE 'starts 03%' ORDER BY dept, number, section ASC";