show all records if the users chose all

[leetkrew]

Hi there,

i have a dropdown that allows the users to select a specific option, or list all records.

I have a working MS SQL stored procedure, however i need to migrate this in MySQL

Here's the SQL Server codes

ALTER procedure recordsList
	@membershipType varchar(10) = 'all'
as
begin
	select * from records r where
        (r.membershipStatus = @status or @status = 'all')

MySQL code

[Weedpacket]

MySQL documentation

[NogDog]

Is your intent to use a stored procedure in MySQL, as well? (Seems a bit of overkill for something like this.)