Mysql Use Concat To Combine Two Or More Field In A Table
- Forums
- MySQL
- Mysql Use Concat To Combine Two Or More Field In A Table
this will show you a simple way to use concat command in mysql query [934], Last Updated: Sat May 18, 2024
wallpaperama
Thu Nov 24, 2011
0 Comments
271 Visits
lets say we have a table called employees, and we want t query and combine the id, name, work_date rows into one. you can use something like this:
SELECT CONCAT(id, name, work_date) FROM employees WHERE employeeId = 2;