MySQL Forums
Forum List  »  Stored Procedures

Re: Eliminate NAME_CONST to Allow Index Usage
Posted by: Shaun Martinec
Date: April 17, 2013 04:59PM

I should have posted that I solved this earlier today by doing just that:
SET current_first_name = 'Joe';
SELECT id INTO current_id FROM names WHERE first_name = CONVERT(current_first_name USING ascii) COLLATE ascii_general_ci LIMIT 1;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Eliminate NAME_CONST to Allow Index Usage
4097
April 17, 2013 04:59PM


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.