Member Avatar

SELECT name,SUBSTRING(name,1,LOCATE('_',name)-1) FROM `student`

how to echo the substring??

  • 2 Contributors
  • forum 1 Reply
  • 129 Views
  • 6 Hours Discussion Span
  • comment Latest Post Latest Post by diafol
Member Avatar 
"SELECT name, SUBSTRING(name,1,LOCATE('_',name)-1) AS subs FROM `student`"

Now you can ref it something like: $row

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!