I have a MYSQL database which has a student name, year and register number(rno) fields.
In this rno filed length is 8 characters
I use PHP with this query
$result="select * from $tabname where RNO like '%$rno%'"
My problem is, I have some hundred candidates whose register number length is only 4
The regular length is 8 eg. 56001234
Some have like this 1034
How to get the rno for such candidates
Please help
In this rno filed length is 8 characters
I use PHP with this query
$result="select * from $tabname where RNO like '%$rno%'"
My problem is, I have some hundred candidates whose register number length is only 4
The regular length is 8 eg. 56001234
Some have like this 1034
How to get the rno for such candidates
Please help
Comment