select BAR_fname,BAR_lname,BAR_empid,BAR_userid,BAR_date_of_regn from boomerang_alumni_registration where BAR_status="current";
i am getting the below exception while executing the query please let me know what's wrong with the query
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"curr' at line 2
And a reminder use two single quotes (not the double quotes character) to include an actual single quote within the text of the query. Such as: SELECT * FROM widgets WHERE name = 'O''brian'