自定义类型自动增量id codeigniter

Question

I have a table called user in my mysql database. I have an auto increment id field and a member_id field. and another radio button for choosing package. S for standard and P for premium. I want to set my member id as P000001 or S000001 for the first id according to the chosen package.

For example if the first member choose P his member_id will be P000001
            if the second member choose S his member_id will be S000002
            if the third member choose S his member_id will be S000003
            ...
            ...

The member_id will be exact 7 in length with P or S.

Answer 1

You can simply use this query

select lpad(member_id,8,'0')
from table
where id = 1