SELECT name,SUBSTRING(name,1,LOCATE('_',name)-1) FROM `student`
how to echo the substring??
"SELECT name, SUBSTRING(name,1,LOCATE('_',name)-1) AS subs FROM `student`"
Now you can ref it something like: $row
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.