MySQL Forums
Forum List  »  Newbie

Re: simple select query
Posted by: Puiu Hrenciuc
Date: April 08, 2005 08:45AM

I wonder if this works :

SELECT student.StudentID, student.Surname, student.Forename, student.AddressIN
FROM student
WHERE student.Surname=[surname_to_search] OR [surname_to_search]="";

I teted and it looks ok;

Options: ReplyQuote


Subject
Written By
Posted
April 07, 2005 10:02AM
April 07, 2005 10:04AM
April 07, 2005 10:29AM
April 07, 2005 09:33PM
April 08, 2005 08:04AM
Re: simple select query
April 08, 2005 08:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.