Hello I would like to make a question: I'm creating a list with a scripting lenguage with MySql database. The list presents username, first name and last name of persons. It has three pairs of filters for username, first name and last name. For each of them the user of the list can type a text as limit for his field with a from and until manner. I would like to create this query with regexp, but i can't make it work. An example of working in this:
Username First name Last name ------------------------------------------------------------- alberto alberto gomez ariel ariel ramirez leandro lean123 pass123 with this filters: username from 'a' until 'le' first name from 'al' until 'lean' there should be the hole list but with this filters: username from 'a' until 'la' first name from 'al' until 'lean' there should be this list: Username First name Last name ------------------------------------------------------------- alberto alberto gomez ariel ariel ramirez I hope i was clear and you could help me with this. Thanks Lionel Pitaru