CONCAT returns NULL if any one field contain NULL value in MySQL: Solved

By -

As per MySQL documentation CONCAT() returns NULL if any argument is NULL.

So, we need to use CONCAT with IFNULL.

For Example

SELECT

  CONCAT( IFNULL(`contact_name`, ''),' ',IFNULL(`last_name`, '')) AS full_name

FROM `users`


Comments

Post a Comment

Popular posts from this blog

Apexcharts not re-render after ajax call - Solved

By -
  render() method just once in the beginning even with empty array, then call the updateSeries() method in ajax call to update data of the chart. var options = { series: [{   name: 'Completed trips',   data: [] }, {   name: 'Cancelled trips',   data: [] }], chart: {   height: 350,   type: 'bar',   toolbar: { show: false },   zoom: { enabled: false } }, plotOptions: {   bar: { horizontal: false, columnWidth: '55%', endingShape: 'rounded'   }, }, dataLabels: { enabled: false }, stroke: {   show: true,   width: 2,   colors: ['transparent'] }, fill: { colors: ['#ffc074', '#6e6e6e'] }, markers: { colors:  ['#ffc074', '#6e6e6e'] }, legend: {   markers: { fillColors: ['#ffc074', '#6e6e6e'] } }, noData: { text: 'Loading...'}, xaxis: {   categories: ['Jan','Feb', 'Mar', 'Apr', 'May...
Read more

Redirect http to https in codeigniter

By -
Follow below steps to redirect you non-http site to https without using .htaccess Change Configuration: go to application/config/config.php and enable hooks to true              $config['enable_hooks'] = TRUE; Create new file hooks.php if not exist other wise open file and paste code           $hook['post_controller_constructor'][] = array(                                 'function' => 'redirect_ssl',                                 'filename' => 'ssl.php',                                 'filepath' => 'hooks'                                 ); Now create a new folder hooks if ...
Read more