... I need to sort out all B that only has CAPITAL letter inside the letter and the out put will be displayed like this

A B
"1" "SAntOsh"
"2" "SAuraV"
"5" "SAthiYa"

Please help me out for this question

Thanks in Advance

You need a regular expression. Something like this will match rows that contain at least one capital letter in the remainder of the field:

MySQL Syntax (Toggle Plain Text)

SELECT * FROM myTable WHERE myField REGEXP 'CAPS.*[A-z]';

select * from myTable where myField regexp 'CAPS.*[A-z]';

hi Fest3er

Thanks for giving the reply

but when I try which querry you send me but it doesn't give the out put

select * from student where b regexp 'CAPS.*[A-z]';

Please help me out.

thanks