I have some user input i am receiving from some forms exactly in this format
The problem is,some forms come with incomplete data which is acceptable during the filling of the form which leaves me with data of the form
names#Age and the rest of the data is not there.
Since there are many records i want first to process the data with all the four fields with data and i want to use regular expressions to select all those complete records first.
I have tried this query
SELECT text_message from incoming_sms where text_message REGEXP '^([a-z]+$)*[a-z]+$';
but this does not match what i want.